[Bio] / BioSimScratch / checkFile.sql Repository:
ViewVC logotype

View of /BioSimScratch/checkFile.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1.1.1 - (download) (annotate) (vendor branch)
Fri Dec 20 20:16:23 2002 UTC (16 years, 9 months ago) by efrank
Branch: local, MAIN
CVS Tags: post-st-migration2, baseline, mass-spec-01, sc2004-3, mass-spec-02, ldrd-2003-01, post-st-migration, forRick-14Jul04-1, forRick-14Jul04-0, sc2004-4, sc04-finalDay, sc2004-2, sc2004-1, sc2004-0, HEAD
Changes since 1.1: +0 -0 lines

Import baseline version

/* following code cut from Oracle docs.   efrank 4nov02 */
/* */
CREATE OR REPLACE PROCEDURE arf IS
Lob_loc       BFILE := BFILENAME('BIOFILES', 'snoopy');
BEGIN
/* Select the LOB: */  
/* SELECT Model INTO Lob_loc FROM ProcList
WHERE ProcId = 115; */
IF (DBMS_LOB.FILEEXISTS(Lob_loc) != 0)
THEN
DBMS_OUTPUT.PUT_LINE('Processing given that the BFILE exists');
ELSE
DBMS_OUTPUT.PUT_LINE('Processing given that the BFILE does not exist');
END IF;
END;

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3