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