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:
o
o grant CREATE TYPE to <username>;
o grant CREATE ANY DIRECTORY to <username>;
o grant CREATE TABLE to <username>;
o grant CREATE SESSION to <username>;
o grant CREATE PROCEDURE to <username>;
o 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