VISUAL BASIC Large Objects(LOBs) EXAMPLES 4/28/00 

DOC REF         DEMO NAME       DESCRIPTION

Internal Persistant LOBs
* For the "DEMO NAME", the Internal Persistant LOBs examples have a prefix = i

adlv001i        iinsert         inserting a row by initializing lob locator bind variable
adlv002i        iload           loading a lob with data from a bfile
adlv003i        ichecko         checking out a lob
adlv004i        ichecki         checking in a lob
adlv005i        idisplay        displaying lob data
adlv006i        iread           reading data from lob
adlv007i        ireadprt        reading portion of the lob (substr)
adlv008i        icompare        comparing all or part of two lobs
adlv009i        ilength         getting length of a lob
adlv010i        icopy           copying all or part of a lob to another lob
adlv011i        icopyloc        copying lob locator
adlv012i        iappend         appending one lob to another
adlv013i        iwrite          writing data to a lob
adlv014i        itrim           trimming lob data
adlv015i        ierase          erasing part of a lob
adlv016i        iflush          flushing the lob buffer
adlv017i        idisbuff        disabling lob buffering
adlv018i        iupdate         updating by initializing lob locator bind variable

Temporary LOBs
No visual basic temporary lob examples are available for Oracle8i Release 2(8.1.6). See Release 8.2.

External LOBs (Bfiles)
* For the "DEMO NAME", the External LOBs (bfile) examples have a prefix = f

adlv019f        finsertn        inserting a row by means of BFILENAME()
adlv020f        finsertb        inserting a row containing a bfile by initializing bfile locator
adlv021f        fload           loading a lob with bfile data
adlv022f        fopen           opening a bfile with OPEN
adlv023f        fisopen         seeing if bfile is open with ISOPEN
adlv024f        fdisplay        displaying bfile data
adlv025f        fread           reading data from a bfile
adlv026f        freadprt        reading portion of bfile data (substr)
adlv027f        fcompare        comparing all or parts of two bfiles
adlv028f        fexists         seeing if the bfile exists
adlv029f        flength         getting the length of the bfile
adlv030f        fgetdir         getting directory alias and file name
adlv031f        fupdate         updating a bfile by initializing a bfile locator
adlv032f        fclose          closing a bfile with close
adlv033f        fclosea         closing all open bfiles
