Stored Procedures
This appendix is intended as a reference document for those trying to lookup and/or find out how to do a specific kind of stored procedure call. 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. Stored procedure with a date, string, and number as parameters
2. Stored procedure using an array of numbers as a parameter
3. Stored procedure using an array of strings as a parameter
The following assumptions are made:
• The reader has Oracle installed and has the proper permissions to create and execute stored procedures. 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:
If you are unable to setup the stored procedure part in the composition editor to do one of the calls listed below then it is recommended you use the sample code in this document and execute the stored procedure using an event to method connection. ..
VAST parts are not available for SQLite and PostgreSQL
Last modified date: 02/27/2021