Skip Headers
Oracle® Database SecureFiles and Large Objects Developer's Guide
11g Release 1 (11.1)

Part Number B28393-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

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 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 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 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



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 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 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 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 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

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 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


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 All or Part of One LOB to Another LOB


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