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 VA 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.
Last modified date: 02/27/2021