A
LOB Demonstration Files

This appendix describes files distributed with the database that demonstrate how LOBs are used in supported programmatic environments.

PL/SQL LOB Demonstration Files

The following table lists PL/SQL demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/plsql/.

Table A-1 PL/SQL Demonstration Examples

File Name	Description	Usage Information
fclose_c.sql	Closing a BFILE with CLOSE	Closing a BFILE with CLOSE
fclose_f.sql	Closing a BFILE with FILECLOSE	Closing a BFILE with FILECLOSE
fclosea.sql	Closing all open BFILEs	Closing All Open BFILEs with FILECLOSEALL
fcompare.sql	Comparing all or parts of two BFILES	Comparing All or Parts of Two BFILES
fcopyloc.sql	Copying a LOB locator for a BFILE	Assigning a BFILE Locator
fdisplay.sql	Displaying BFILE data	Displaying BFILE Data
fexists.sql	Checking if a BFILE exists	Determining Whether a BFILE Exists
ffilopen.sql	Opening a BFILE with FILEOPEN	Opening a BFILE with FILEOPEN
ffisopen.sql	Checking if the BFILE is OPEN with FILEISOPEN	Determining Whether a BFILE Is Open with FILEISOPEN
fgetdir.sql	Getting the directory object name and filename of a BFILE	Getting Directory Object Name and Filename of a BFILE
finsert.sql	Inserting row containing a BFILE by initializing a BFILE locator	Inserting a Row Containing a BFILE
fisopen.sql	Checking if the BFILE is open with ISOPEN	Determining Whether a BFILE Is Open Using ISOPEN
flength.sql	Getting the length of a BFILE	Getting the Length of a BFILE
floadlob.sql	Loading a LOB with BFILE data	Loading a LOB with BFILE Data
fopen.sql	Opening a BFILE with OPEN	Opening a BFILE with OPEN
fpattern.sql	Checking if a pattern exists in a BFILE using instr	Checking If a Pattern Exists in a BFILE Using INSTR
fread.sql	Reading data from a BFILE	Reading Data from a BFILE
freadprt.sql	Reading portion of a BFILE data using substr	Reading a Portion of BFILE Data Using SUBSTR
fupdate.sql	Updating a BFILE by initializing a BFILE locator	Updating a BFILE by Initializing a BFILE Locator
lappend.sql	Appending one LOB to another	Appending One LOB to Another
lcompare.sql	Comparing all or part of LOB	Comparing All or Part of Two LOBs
lcopy.sql	Copying all or part of a LOB to another LOB	Copying All or Part of One LOB to Another LOB
lcopyloc.sql	Copying a LOB locator	Copying a LOB Locator
ldisplay.sql	Displaying LOB data	Displaying LOB Data
lerase.sql	Erasing part of a LOB	Erasing Part of a LOB
linsert.sql	Inserting a row by initializing LOB locator bind variable	Inserting a Row by Initializing a LOB Locator Bind Variable
linstr.sql	Seeing if pattern exists in LOB (instr)	Patterns: Checking for Patterns in a LOB Using INSTR
lisopen.sql	Seeing if LOB is open	Determining Whether a LOB is Open
listemp.sql	Seeing if LOB is temporary	Determining Whether a LOB instance Is Temporary
lldblobf.sql	Using DBMS_LOB.LOADBLOBFROMFILE to load a BLOB with data from a BILE	Loading a BLOB with Data from a BFILE
lldclobf.sql	Using DBMS_LOB.LOADCLOBFROMFILE to load a CLOB or NCLOB with data from a BILE	Loading a CLOB or NCLOB with Data from a BFILE
lldclobs.sql	Using DBMS_LOB.LOADCLOBFROMFILE to load segments of a stream of data from a BFILE into different CLOBs	Loading a CLOB or NCLOB with Data from a BFILE
llength.sql	Getting the length of a LOB	Length: Determining the Length of a LOB
lloaddat.sql	Loading a LOB with BFILE data	Loading a LOB with Data from a BFILE
lobuse.sql	Examples of LOB API usage.	Creating Persistent and Temporary LOBs in PL/SQL
lread.sql	Reading data from LOB	Reading Data from a LOB
lsubstr.sql	Reading portion of LOB (substr)	Reading a Portion of a LOB (SUBSTR)
ltrim.sql	Trimming LOB data	Trimming LOB Data
lwrite.sql	Writing data to a LOB	Writing Data to a LOB
lwriteap.sql	Writing to the end of LOB (write append)	Appending to a LOB

fcopyloc.sql

OCI LOB Demonstration Files

The following table lists OCI demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/oci/.

Table A-2 OCI Demonstration Examples

File Name	Description	Usage Information
fclose_c.c	Closing a BFILE with CLOSE	Closing a BFILE with CLOSE
fclose_f.c	Closing a BFILE with FILECLOSE	Closing a BFILE with FILECLOSE
fclosea.c	Closing all open BFILEs	Closing All Open BFILEs with FILECLOSEALL
fcopyloc.c	Copying a LOB locator for a BFILE	Assigning a BFILE Locator
fdisplay.c	Displaying BFILE data	Displaying BFILE Data
fexists.c	Checking if a BFILE exists	Determining Whether a BFILE Exists
ffilopen.c	Opening a BFILE with FILEOPEN	Opening a BFILE with FILEOPEN
ffisopen.c	Checking if the BFILE is OPEN with FILEISOPEN	Determining Whether a BFILE Is Open with FILEISOPEN
fgetdir.c	Getting the directory object name and filename of a BFILE	Getting Directory Object Name and Filename of a BFILE
finsert.c	Inserting row containing a BFILE by initializing a BFILE locator	Inserting a Row Containing a BFILE
fisopen.c	Checking if the BFILE is open with ISOPEN	Determining Whether a BFILE Is Open Using ISOPEN
flength.c	Getting the length of a BFILE	Getting the Length of a BFILE
floadlob.c	Loading a LOB with BFILE data	Loading a LOB with BFILE Data
fopen.c	Opening a BFILE with OPEN	Opening a BFILE with OPEN
fread.c	Reading data from a BFILE	Reading Data from a BFILE
fupdate.c	Updating a BFILE by initializing a BFILE locator	Updating a BFILE by Initializing a BFILE Locator
lappend.c	Appending one LOB to another	Appending One LOB to Another
lcopy.c	Copying all or part of a LOB to another LOB	Copying All or Part of One LOB to Another LOB
lcopyloc.c	Copying a LOB locator	Copying a LOB Locator
ldisbuf.c	Disabling LOB buffering (persistent LOBs)	Disabling LOB Buffering
ldisplay.c	Displaying LOB data	Displaying LOB Data
lequal.c	Seeing if one LOB locator is equal to another	Equality: Checking If One LOB Locator Is Equal to Another
lerase.c	Erasing part of a LOB	Erasing Part of a LOB
lgetchar.c	Getting character set id	Determining Character Set ID
lgetchfm.c	Getting character set form of the foreign language ad text, ad_fltextn	Determining Character Set Form
linit.c	Seeing if a LOB locator is initialized	Determining Whether LOB Locator Is Initialized
linsert.c	Inserting a row by initializing LOB locator bind variable	Inserting a Row by Initializing a LOB Locator Bind Variable
lisopen.c	Seeing if LOB is open	Determining Whether a LOB is Open
listemp.c	Seeing if LOB is temporary	Determining Whether a LOB instance Is Temporary
llength.c	Getting the length of a LOB	Length: Determining the Length of a LOB
lloaddat.c	Loading a LOB with BFILE data	Loading a LOB with Data from a BFILE
lread.c	Reading data from LOB	Reading Data from a LOB
ltrim.c	Trimming LOB data	Trimming LOB Data
lwrite.c	Writing data to a LOB	Writing Data to a LOB
lwriteap.c	Writing to the end of LOB (write append)	Appending to a LOB

Pro*COBOL LOB Demonstration Files

The following table lists Pro*COBOL demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/procob/.

***Table A-3 Pro*COBOL Demonstration Examples***

File Name	Description	Usage Information
fclose_c.pco	Closing a BFILE with CLOSE	Closing a BFILE with CLOSE
fclosea.pco	Closing all open BFILEs	Closing All Open BFILEs with FILECLOSEALL
fcompare.pco	Comparing all or parts of two BFILES	Comparing All or Parts of Two BFILES
fcopyloc.pco	Copying a LOB locator for a BFILE	Assigning a BFILE Locator
fdisplay.pco	Displaying BFILE data	Displaying BFILE Data
fexists.pco	Checking if a BFILE exists	Determining Whether a BFILE Exists
fgetdir.pco	Getting the directory object name and filename of a BFILE	Getting Directory Object Name and Filename of a BFILE
finsert.pco	Inserting row containing a BFILE by initializing a BFILE locator	Inserting a Row Containing a BFILE
fisopen.pco	Checking if the BFILE is open with ISOPEN	Determining Whether a BFILE Is Open Using ISOPEN
flength.pco	Getting the length of a BFILE	Getting the Length of a BFILE
floadlob.pco	Loading a LOB with BFILE data	Loading a LOB with BFILE Data
fopen.pco	Opening a BFILE with OPEN	Opening a BFILE with OPEN
fpattern.pco	Checking if a pattern exists in a BFILE using instr	Checking If a Pattern Exists in a BFILE Using INSTR
fread.pco	Reading data from a BFILE	Reading Data from a BFILE
freadprt.pco	Reading portion of a BFILE data using substr	Reading a Portion of BFILE Data Using SUBSTR
fupdate.pco	Updating a BFILE by initializing a BFILE locator	Updating a BFILE by Initializing a BFILE Locator
lappend.pco	Appending one LOB to another	Appending One LOB to Another
lcompare.pco	Comparing all or part of LOB	Comparing All or Part of Two LOBs
lcopy.pco	Copying all or part of a LOB to another LOB	Copying All or Part of One LOB to Another LOB
lcopyloc.pco	Copying a LOB locator	Copying a LOB Locator
ldisbuf.pco	Disabling LOB buffering (persistent LOBs)	Disabling LOB Buffering
ldisplay.pco	Displaying LOB data	Displaying LOB Data
lenbuf.pco	Enabling LOB buffering	Enabling LOB Buffering
lerase.pco	Erasing part of a LOB	Erasing Part of a LOB
lflbuf.pco	Flushing the LOB buffer (persistent LOBs)	Flushing the Buffer
linsert.pco	Inserting a row by initializing LOB locator bind variable	Inserting a Row by Initializing a LOB Locator Bind Variable
linstr.pco	Seeing if pattern exists in LOB (instr)	Patterns: Checking for Patterns in a LOB Using INSTR
lisopen.pco	Seeing if LOB is open	Determining Whether a LOB is Open
listemp.pco	Seeing if LOB is temporary	Determining Whether a LOB instance Is Temporary
llength.pco	Getting the length of a LOB	Length: Determining the Length of a LOB
lloaddat.pco	Loading a LOB with BFILE data	Loading a LOB with Data from a BFILE
lread.pco	Reading data from LOB	Reading Data from a LOB
lsubstr.pco	Reading portion of LOB (substr)	Reading a Portion of a LOB (SUBSTR)
ltrim.pco	Trimming LOB data	Trimming LOB Data
lwrite.pco	Writing data to a LOB	Writing Data to a LOB
lwriteap.pco	Writing to the end of LOB (write append)	Appending to a LOB

Pro*C LOB Demonstration Files

The following table lists Pro*C demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/proc/.

***Table A-4 Pro*C Demonstration Examples***

File Name	Description	Usage Information
fclose_c.pc	Closing a BFILE with CLOSE	Closing a BFILE with CLOSE
fclosea.pc	Closing all open BFILEs	Closing All Open BFILEs with FILECLOSEALL
fcompare.pc	Comparing all or parts of two BFILES	Comparing All or Parts of Two BFILES
fcopyloc.pc	Copying a LOB locator for a BFILE	Assigning a BFILE Locator
fdisplay.pc	Displaying BFILE data	Displaying BFILE Data
fexists.pc	Checking if a BFILE exists	Determining Whether a BFILE Exists
fgetdir.pc	Getting the directory object name and filename of a BFILE	Getting Directory Object Name and Filename of a BFILE
finsert.pc	Inserting row containing a BFILE by initializing a BFILE locator	Inserting a Row Containing a BFILE
fisopen.pc	Checking if the BFILE is open with ISOPEN	Determining Whether a BFILE Is Open Using ISOPEN
flength.pc	Getting the length of a BFILE	Getting the Length of a BFILE
floadlob.pc	Loading a LOB with BFILE data	Loading a LOB with BFILE Data
fopen.pc	Opening a BFILE with OPEN	Opening a BFILE with OPEN
fpattern.pc	Checking if a pattern exists in a BFILE using instr	Checking If a Pattern Exists in a BFILE Using INSTR
fread.pc	Reading data from a BFILE	Reading Data from a BFILE
freadprt.pc	Reading portion of a BFILE data using substr	Reading a Portion of BFILE Data Using SUBSTR
fupdate.pc	Updating a BFILE by initializing a BFILE locator	Updating a BFILE by Initializing a BFILE Locator
lappend.pc	Appending one LOB to another	Appending One LOB to Another
lcompare.pc	Comparing all or part of LOB	Comparing All or Part of Two LOBs
lcopy.pc	Copying all or part of a LOB to another LOB	Copying All or Part of One LOB to Another LOB
lcopyloc.pc	Copying a LOB locator	Copying a LOB Locator
ldisbuf.pc	Disabling LOB buffering (persistent LOBs)	Disabling LOB Buffering
ldisplay.pc	Displaying LOB data	Displaying LOB Data
lenbuf.pc	Enabling LOB buffering	Enabling LOB Buffering
lequal.pc	Seeing if one LOB locator is equal to another	Equality: Checking If One LOB Locator Is Equal to Another
lerase.pc	Erasing part of a LOB	Erasing Part of a LOB
lflbuf.pc	Flushing the LOB buffer (persistent LOBs)	Flushing the Buffer
linit.pc	Seeing if a LOB locator is initialized	Determining Whether LOB Locator Is Initialized
linsert.pc	Inserting a row by initializing LOB locator bind variable	Inserting a Row by Initializing a LOB Locator Bind Variable
linstr.pc	Seeing if pattern exists in LOB (instr)	Patterns: Checking for Patterns in a LOB Using INSTR
lisopen.pc	Seeing if LOB is open	Determining Whether a LOB is Open
listemp.pc	Seeing if LOB is temporary	Determining Whether a LOB instance Is Temporary
llength.pc	Getting the length of a LOB	Length: Determining the Length of a LOB
lread.pc	Reading data from LOB	Reading Data from a LOB
lsubstr.pc	Reading portion of LOB (substr)	Reading a Portion of a LOB (SUBSTR)
ltrim.pc	Trimming LOB data	Trimming LOB Data
lwrite.pc	Writing data to a LOB	Writing Data to a LOB
lwriteap.pc	Writing to the end of LOB (write append)	Appending to a LOB

Visual Basic OO4O LOB Demonstration Files

The following table lists Visual Basic OO4O demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/vb/.

Table A-5 Visual Basic OO4O Demonstration Examples

File Name	Description	Usage Information
fclose_c.bas	Closing a BFILE with CLOSE	Closing a BFILE with CLOSE
fclosea.bas	Closing all open BFILEs	Closing All Open BFILEs with FILECLOSEALL
fcompare.bas	Comparing all or parts of two BFILES	Comparing All or Parts of Two BFILES
fdisplay.bas	Displaying BFILE data	Displaying BFILE Data
fexists.bas	Checking if a BFILE exists	Determining Whether a BFILE Exists
fgetdir.bas	Getting the directory object name and filename of a BFILE	Getting Directory Object Name and Filename of a BFILE
finsert.bas	Inserting row containing a BFILE by initializing a BFILE locator	Inserting a Row Containing a BFILE
fisopen.bas	Checking if the BFILE is open with ISOPEN	Determining Whether a BFILE Is Open Using ISOPEN
flength.bas	Getting the length of a BFILE	Getting the Length of a BFILE
floadlob.bas	Loading a LOB with BFILE data	Loading a LOB with BFILE Data
fopen.bas	Opening a BFILE with OPEN	Opening a BFILE with OPEN
fread.bas	Reading data from a BFILE	Reading Data from a BFILE
freadprt.bas	Reading portion of a BFILE data using substr	Reading a Portion of BFILE Data Using SUBSTR
fupdate.bas	Updating a BFILE by initializing a BFILE locator	Updating a BFILE by Initializing a BFILE Locator
lappend.bas	Appending one LOB to another	Appending One LOB to Another
lcompare.bas	Comparing all or part of LOB	Comparing All or Part of Two LOBs
lcopy.bas	Copying all or part of a LOB to another LOB	Copying All or Part of One LOB to Another LOB
lcopyloc.bas	Copying a LOB locator	Copying a LOB Locator
ldisbuf.bas	Disabling LOB buffering (persistent LOBs)	Disabling LOB Buffering
ldisplay.bas	Displaying LOB data	Displaying LOB Data
lenbuf.bas	Enabling LOB buffering	Enabling LOB Buffering
lerase.bas	Erasing part of a LOB	Erasing Part of a LOB
linsert.bas	Inserting a row by initializing LOB locator bind variable	Inserting a Row by Initializing a LOB Locator Bind Variable
llength.bas	Getting the length of a LOB	Length: Determining the Length of a LOB
lloaddat.bas	Loading a LOB with BFILE data	Loading a LOB with Data from a BFILE
lread.bas	Reading data from LOB	Reading Data from a LOB
lsubstr.bas	Reading portion of LOB (substr)	Reading a Portion of a LOB (SUBSTR)
ltrim.bas	Trimming LOB data	Trimming LOB Data
lwrite.bas	Writing data to a LOB	Writing Data to a LOB

Java LOB Demonstration Files

The following table lists Java demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/java/.

Table A-6 Java Demonstration Examples

File Name	Description	Usage Information
fclose_c.java	Closing a BFILE with CLOSE	Closing a BFILE with CLOSE
fclose_f.java	Closing a BFILE with FILECLOSE	Closing a BFILE with FILECLOSE
fclosea.java	Closing all open BFILEs	Closing All Open BFILEs with FILECLOSEALL
fcompare.java	Comparing all or parts of two BFILES	Comparing All or Parts of Two BFILES
fcopyloc.java	Copying a LOB locator for a BFILE	Assigning a BFILE Locator
fdisplay.java	Displaying BFILE data	Displaying BFILE Data
fexists.java	Checking if a BFILE exists	Determining Whether a BFILE Exists
ffilopen.java	Opening a BFILE with FILEOPEN	Opening a BFILE with FILEOPEN
ffisopen.java	Checking if the BFILE is OPEN with FILEISOPEN	Determining Whether a BFILE Is Open with FILEISOPEN
fgetdir.java	Getting the directory object name and filename of a BFILE	Getting Directory Object Name and Filename of a BFILE
finsert.java	Inserting row containing a BFILE by initializing a BFILE locator	Inserting a Row Containing a BFILE
fisopen.java	Checking if the BFILE is open with ISOPEN	Determining Whether a BFILE Is Open Using ISOPEN
flength.java	Getting the length of a BFILE	Getting the Length of a BFILE
fopen.java	Opening a BFILE with OPEN	Opening a BFILE with OPEN
fpattern.java	Checking if a pattern exists in a BFILE using instr	Checking If a Pattern Exists in a BFILE Using INSTR
fread.java	Reading data from a BFILE	Reading Data from a BFILE
freadprt.java	Reading portion of a BFILE data using substr	Reading a Portion of BFILE Data Using SUBSTR
fupdate.java	Updating a BFILE by initializing a BFILE locator	Updating a BFILE by Initializing a BFILE Locator
lappend.java	Appending one LOB to another	Appending One LOB to Another
lcompare.java	Comparing all or part of LOB	Comparing All or Part of Two LOBs
lcopy.java	Copying all or part of a LOB to another LOB	Copying All or Part of One LOB to Another LOB
lcopyloc.java	Copying a LOB locator	Copying a LOB Locator
ldisplay.java	Displaying LOB data	Displaying LOB Data
lequal.java	Seeing if one LOB locator is equal to another	Equality: Checking If One LOB Locator Is Equal to Another
lerase.java	Erasing part of a LOB	Erasing Part of a LOB
linsert.java	Inserting a row by initializing LOB locator bind variable	Inserting a Row by Initializing a LOB Locator Bind Variable
linstr.java	Seeing if pattern exists in LOB (instr)	Patterns: Checking for Patterns in a LOB Using INSTR
lisopen.java	Seeing if LOB is open	Determining Whether a LOB is Open
listempb.java	Seeing if LOB is temporary	Determining Whether a LOB instance Is Temporary
listempc.java	Seeing if LOB is temporary	Determining Whether a LOB instance Is Temporary
llength.java	Getting the length of a LOB	Length: Determining the Length of a LOB
lloaddat.java	Loading a LOB with BFILE data	Loading a LOB with Data from a BFILE
lread.java	Reading data from LOB	Reading Data from a LOB
lsubstr.java	Reading portion of LOB (substr)	Reading a Portion of a LOB (SUBSTR)
ltrim.java	Trimming LOB data	Trimming LOB Data
lwrite.java	Writing data to a LOB	Writing Data to a LOB
lwriteap.java	Writing to the end of LOB (write append)	Appending to a LOB
oldtrim.java	Old way of trimming LOB data	Trimming LOB Data

A LOB Demonstration Files