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 Using DBMS Data with the SQL Pass-Through Facility for usage examples. The SQL Procedure Pass-Through Facility consists of three statements and one component: The CONNECT statement establishes a ...