Pro*C/C++ Large Object(LOBs) EXAMPLES  5/15/00
/rdbms/demo/lobs/pc examples

Note:
These lob examples are available in /rdbms/demo/lobs for the first time in 
Oracle8i release 3 (8.1.7). 
The example scripts, are taken from the "Oracle8i Application Developer's Guide - 
Large Objects (LOBs)" release 2 (8.1.6). The majority of these examples 
are based on the multimedia_tab schema. The set up and clean up scripts for 
these examples are described in the manual at the beginning of chapters 9,10,
and 11, and can also be found here in the file:
On UNIX:/rdbms/demo/adlsetup.sql
On NT: $HOME\demo\adlsetup.sql


DOC REF		DEMO NAME	DESCRIPTION

Pro*C/C++ Internal Persistant LOBs Examples from Chapter 9
* For the "DEMO NAME", the Internal Persistant LOBs examples have a prefix = i

adlc001i	iinsert		inserting row by initializing lob locator bind variable
adlc002i	iload		loading lob with data from bfile
adlc003i	iifopen		seeing if lob is open
adlc004i	ichecko		checking out a lob
adlc005i	ichecki		checking in a lob
adlc006i	idisplay	displaying lob data
adlc007i	iread		reading data from lob
adlc008i	ireadprt	reading portion of the lob (substr)	
adlc009i	icompare	comparing all or part of two lobs
adlc010i	ipattern	seeing if pattern exists in lob (instr)
adlc011i	ilength		getting length of a lob
adlc012i	icopy		copying all or part of a lob to another lob
adlc013i	icopyloc	copying a lob locator
adlc014i	iequal		seeing if one lob locator is equal to another
adlc015i	iinital		seeing if lob locator is initialized
adlc016i	iappend		appending one lob to another
adlc017i	iwrite		writing data to a lob
adlc018i	itrim 		trimming lob data
adlc019i	ierase		erasing part of a lob
adlc020i	ibuffer		enabling lob buffering
adlc021i	iflush		flushing the lob buffer
adlc022i	idisbuff	disabling lob buffering
adlc023i	iupdate		updating by initializing a lob locator bind variable
adlc066i	iwriteap	writing to the end of a lob (write append)

Pro*C/C++ Temporary LOBs Examples from Chapter 10
* For the "DEMO NAME", the Temporary LOBs examples have a prefix = t
	
adlc024t	tcreate		creating a temporary lob
adlc025t	tiftemp		seeing if lob is temporary
adlc026t	tfree		freeing a temporary lob
adlc027t	tload		loading a temporary lob with data from a bfile
adlc028t	tifopen		seeing if temporary lob is open
adlc029t	tdisplay	displaying temporary lob data
adlc030t	tread		reading data from a temporary lob
adlc031t	treadprt	reading portion of a temporary lob (instr)
adlc032t	tcompare	comparing all or part of two (temporary) lobs
adlc033t	tpattern	seeing if a pattern exists in a temporary lob
adlc034t	tlength		getting the length of a temporary lob
adlc035t	tcopy		copying all or part of a temporary lob to another
adlc036t	tcopyloc	copying a lob locator for a temporary lob
adlc037t	tequal		seeing if one lob locator for a temporary lob is equal to another
adlc038t	tinitial	seeing if a lob locator for a temporary lob is initialized
adlc039t	tappend		appending one temporary lob to another
adlc040t	twriteap	writing to the end of a temporary lob
adlc041t	twrite		writing data to a temporary lob
adlc042t	ttrim		trimming temporary lob data
adlc043t	terase		erasing part of a temporary lob
adlc044t	tbuffer		enabling lob buffering for a temporary lob
adlc045t	tflush		flushing buffer for a temporary lob
adlc046t	tdisbuf		disabling lob buffering for a temporary lob

Pro*C/C++ External LOBs (Bfiles) Examples from Chapter 11
* For the "DEMO NAME", the External LOBs (bfile) examples have a prefix = f

adlc047f	finsertn	inserting a row using BFILENAME()
adlc048f	finsert		inserting a row containing a bfile by initializing a bfile locator
adlc049f	fload		loading a lob with bfile data
adlc050f	fopen		opening a bfile with OPEN
adlc051f	fisopen		seeing if a bfile is open with ISOPEN
adlc052f	fdisplay	displaying bfile data
adlc053f	fread		reading data from bfile
adlc054f	freadprt	reading portion of bfile data (substr)
adlc055f	fcompare	comparing all or part of two bfiles
adlc056f	fpattern	seeing if a pattern (instr) exists in the bfile
adlc057f	fexists		seeing if the bfile exists
adlc058f	flength		getting the length of a bfile
adlc059f	fcopyloc	copying lob locator for a bfile
adlc060f	finitial	seeing if a lob locator for a bfile is initialized
adlc061f	fequal		seeing if one lob locator for a bfile is equal to another
adlc062f	fgetdir		getting directory alias and filename
adlc063f	fupdate		updating a bfile by initializing a bfile locator
adlc064f	fclose		closing a bfile with CLOSE
adlc065f	fcloseal	closing all open bfiles
	
**********************
