Progammatic Execution of SQL statements
This readme is intended as a reference document for those trying to lookup and/or find out how to programmatically execute a SQL statement. These examples were done with ‘Oracle Database 10g Enterprise Edition Release 10.2.0.1.0’ and VA Smalltalk 7.5.
The following assumptions are made:
•The reader has Oracle installed and has the proper permissions to 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:
If you prefer using a SQL part then most of the statements below can be setup through the SQL settings GUI in the composition editor. If you find you are unable to setup a certain kind of SQL statement then it is recommended you use one of the examples below as a template and use an event connection to a method.
Last modified date: 01/29/2015