Spatial Cartridge provides sample SQL script files to show how to use dynamic ... The altpart.sql script file shows how to use dynamic SQL in a PL/SQL procedure to modify all partitions of a Spatial ...

See Using DBMS Data in Version 7 and Version 8 for examples. If you are using descriptors, you can specify them in the SQL procedure's INSERT, DELETE, and UPDATE statements. You can also use these ...

See SQL Procedure Pass-Through Facility Return Codes for more information on these macro variables. identifies the database management system to which you want to connect. You must specify a DBMS name ...