/
/ $Header: template.txt 06-feb-96.13:23:24 kosinski Exp $
/
/ readme.txt
/
/ Copyright (c) Oracle Corporation 2000. All Rights Reserved.
/
/   NAME
/     readme.txt - <one-line expansion of the name>
/
/   DESCRIPTION
/     <short description of component this file declares/defines>
/
/   NOTES
/     <other useful comments, qualifications, etc.>
/
/   MODIFIED   (MM/DD/YY)
/   jchai       05/22/00 - Creation
/

OCI Large Object(LOBs) EXAMPLES  5/15/00 
(/rdbms/demo/lobs/oci)

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

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

adlo001i        iinsertu        inserting-updating for binds greater than 4000 byte (chapter 7)
adlo002i        iinsert         inserting a row by initializing lob locator bind variable
adlo003i        iloadbf         loading lob with data from a bfile
adlo004i        iisopen         seeing if lob is open
adlo005i        ichkout         checking out a lob
adlo006i        ichkin          checking in a lob
adlo007i        idisplay        displaying lob data
adlo008i        iread           reading data from lob
adlo009i        ilength         getting length of lob
adlo010i        icopy           copying all or part of a lob to another lob
adlo011i        icopyloc        copying a lob locator
adlo012i        iequal          seeing if one lob locator is equal to another
adlo013i        iinit           seeing if lob locator is initialized
adlo014i        igetchar        getting character set id
adlo015i        igetchfm        getting character set form
adlo016i        iappend         appending one lob to another
adlo017i        iwriteap        writing to the end of a lob
adlo018i        iwrite          writing data to a lob
adlo019i        itrim           trimming lob data
adlo020i        ierase          erasing part of a lob
adlo021i        idisable        disabling lob buffering
adlo022i        iupdate         updating by initializing lob locator bind variable

OCI Temporary LOBs Examples from Chapter 10
* For the "DEMO NAME", the Temporary LOBs examples have a prefix = t

adlo023t        tcreate         creating a temporary lob
adlo024t        tiftemp         seeing if lob is temporary
adlo025t        tfree           freeing a temporary lob
adlo026t        tload           loading a temporary lob with data from bfile
adlo027t        tifopen         seeing if temporary lob is open
adlo028t        tdisplay        displaying temporary lob data
adlo029t        tread           reading data from a temporary lob       
adlo030t        tlength         getting length of a temporary lob
adlo031t        tcopy           copying all or part of one (temporary) lob to another
adlo032t        tcopyloc        copying a lob locator for a temporary lob
adlo033t        tequal          seeing if one lob locator for a temp lob is equal to another
adlo034t        tinit           seeing if lob locator for temp lob is initialized
adlo035t        tgetchar        getting character set id of a temporary lob
adlo036t        tgetchfm        getting character set form of a temporary lob
adlo037t        tappend         appending one temporary lob to another
adlo038t        twriteap        writing to the end of a temporary lob
adlo039t        twrite          writing data to a temporary lob
adlo040t        ttrim           trimming temporary lob data
adlo041t        terase          erasing part of a temporary lob
adlo042t        tbuffer         enabling buffering for a temporary lob
adlo043t        tflbuff         flushing buffer for a temporary lob
adlo044t        tdisbuf         disabling buffering for a temporary lob

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

adlo045f        finsertn        inserting a row using BFILENAME()
adlo046f        finstloc        inserting a row containing bfile by initializing bfile locator
adlo047f        floadb          loading lob with bfile data
adlo048f        ffilopen        opening bfile with FILEOPEN
adlo049f        fopen           opening bfile with OPEN
adlo050f        fisopenf        seeing if bfile is open with FILEISOPEN
adlo051f        fisopeni        seeing if bfile is open with ISOPEN
adlo052f        fdisplay        displaying bfile data
adlo053f        fread           reading data from bfile
adlo054f        fexists         seeing if bfile exists
adlo055f        flength         getting length of bfile
adlo056f        fcopyloc        copying lob locator for bfile
adlo057f        fiflocin        seeing if a lob locator for a bfile is initialized
adlo058f        fequal          seeing if one lob locator for a bfile is equal to another
adlo059f        fgetdir         getting directory alias and filename
adlo060f        fupdate         updating bfle by initializing bfile locator
adlo061f        fclose_f        closing bfile with FILECLOSE
adlo062f        fclose_c        closing bfile with CLOSE
adlo063f        fcloseal        closing all open bfiles

****************



