LOB Manipulation

This appendix is intended as a reference document for those trying to lookup and/or find out how to do a specific kind of LOB operation. These examples were done with ‘Oracle Database 10g Enterprise Edition Release 10.2.0.1.0’ and Instantiations Smalltalk 7.5. The following calls are shown/discussed:

1.	Reading and Writing a LOB to/from a buffer

2.	Reading and Writing a LOB to/from a file

3.

BFiles

The following assumptions are made:

•	The reader has Oracle installed and has the proper permissions to create tables and execute SQL statements. The following grants should be done by the administrator:

•

•	grant CREATE TYPE to <username>;

•	grant CREATE ANY DIRECTORY to <username>;

•	grant CREATE TABLE to <username>;

•	grant CREATE SESSION to <username>;

•	grant CREATE PROCEDURE to <username>;

•	grant SELECT ANY TABLE to <username>;

•	The user has the Native Oracle feature loaded into their Smalltalk image.

•	The user has created an access set and is able to log into Oracle from the Smalltalk image.

•	The user has a good working knowledge of Smalltalk and knows how to execute and inspect ST scripts.

 

Note:

The composition editor does not have LOB parts. Therefore, it is recommended you use the sample code in this document as a template and use event to method connections.