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

View of /BioSimScratch/readBfile.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, 10 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 readBfile IS
Lob_loc       BFILE := BFILENAME('BIOFILES', 'snoopy');
Amount        INTEGER := 32767;
Position      INTEGER := 1;
Buffer        Varchar2(32767);
BEGIN
/* Select the LOB: */  
/*SELECT Model INTO Lob_loc FROM ProcList
WHERE ProcId = 115;*/
/* Open the BFILE: */  
DBMS_LOB.OPEN(Lob_loc, DBMS_LOB.LOB_READONLY);
/* Read data: */  
DBMS_LOB.READ(Lob_loc, Amount, Position, Buffer);
/* Close the BFILE: */  
DBMS_LOB.CLOSE(Lob_loc);
END;

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3