Oracle9i Application Developer's Guide - Large Objects (LOBs) Release 1 (9.0.1) Part Number A88879-01 |
|
LOB Support in Different Programmatic Environments, 8 of 11
You can make changes to an entire internal LOB, or to pieces of the beginning, middle or end of it by using embedded SQL. You can access both internal and external LOB
s for read purposes, and you can also write to internal LOB
s.
Embedded SQL statements allow you to access data stored in BLOB
s, CLOB
s, NCLOB
s, and BFILE
s. These statements are listed in the tables below, and are discussed in greater detail later in the manual.
Unlike locators in PL/SQL, locators in Pro*COBOL are mapped to locator pointers which are then used to refer to the LOB or BFILE value. For the successful completion of an embedded SQL LOB statement you must perform the following:
Examples provided with each embedded SQL LOB statement are illustrated in:
You can access these Pro*COBOL LOB example scripts from $ORACLE_HOME/rdbms/demo/lobs/.
Where the Pro*COBOL interface does not supply the required functionality, you can call OCI via C. Such an example is not provided here because such programs are operating system dependent.
See Also:
Pro*COBOL Precompiler Programmer's Guide for detailed documentation, including syntax, host variables, host variable types, and example code. |
The following Pro*COBOL statements operate on BLOBs, CLOBs, NCLOBs, and BFILEs:
Statement | Description |
---|---|
CREATE TEMPORARY |
Creates a temporary LOB. |
DESCRIBE [ISTEMPORARY] |
Sees if a LOB locator refers to a temporary LOB. |
FREE TEMPORARY |
Frees a temporary LOB. |
Statement | Description |
---|---|
ASSIGN |
Assigns one |
FILE SET |
Sets the directory alias and filename of a |
Statement | Description |
---|---|
OPEN |
Opens a LOB or BFILE. |
DESCRIBE [ISOPEN] |
Sees if a LOB or BFILE is open. |
CLOSE |
Closes a LOB or BFILE. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|