A LOB Demonstration Files

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

PL/SQL LOB Demonstration Files
OCI LOB Demonstration Files
COM OO4O LOB Demonstration Files
Java LOB Demonstration Files

PL/SQL LOB Demonstration Files

The following table lists PL/SQL demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/plsql/. A driver program, lobdemo.sql, that calls these files is found in the same directory.

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 `BFILE`s	Closing All Open BFILEs with FILECLOSEALL
`fcompare.sql`	Comparing all or parts of two `BFILE`s	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 File Name 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 All or Part of One LOB to Another LOB
`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 `BFILE`	Loading a BLOB with Data from a BFILE
`lldclobf.sql`	Using `DBMS_LOB.LOADCLOBFROMFILE` to load a `CLOB` or `NCLOB` with data from a `BFILE`	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 `CLOB`s	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

OCI LOB Demonstration Files

The following table lists OCI demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/oci/. A driver program, lobdemo.c, that calls these files is found in the same directory, as is the header file lobdemo.h.

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 `BFILE`s	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 File Name 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 All or Part of One LOB to Another LOB
`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
`lreadarr.c`	Reading data from an array of LOB locators	LOB Array Read
`ltrim.c`	Trimming LOB data	Trimming LOB Data
`lwrite.c`	Writing data to a LOB	Writing Data to a LOB
`lwritearr.c`	Writing data into an array of LOB locators	LOB Array Write
`lwriteap.c`	Writing to the end of LOB (write append)	Appending to a LOB

COM OO4O LOB Demonstration Files

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

Table A-3 COM 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 `BFILE`s	Closing All Open BFILEs with FILECLOSEALL
`fcompare.bas`	Comparing all or parts of two `BFILE`s	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 File Name 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 All or Part of One LOB to Another LOB
`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-4 Java Demonstration Examples

File Name	Description	Usage Information
`Readme.txt`	`-`	See the Chapter "Getting Started" in the "Oracle Database JDBC Developer's Guide and Reference" for information on setting up your system to be able to compile and run JDBC programs with the Oracle Driver
LobDemoConnectionFactory.java	-	As written `LobDemoConnectionFactory` uses the JDBC OCI driver with a local connection. You should edit the URL "jdbc:oracle:oci8:@" to match your setup. Again see the "Getting Started" section in the JDBC manual.
`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 `BFILE`s	Closing All Open BFILEs with FILECLOSEALL
`fcompare.java`	Comparing all or parts of two `BFILE`s	Comparing All or Parts of Two BFILES
`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 File Name 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
`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
`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