There is the need at my organization to process DDL statements contained in a group of SQL files.
I have been able to greatly simplify a number of tasks using perl and I was hoping to likewise be able to use perl and the DBD::Oracle modules to get this accomplished. I would like to know what the known limitations are concerning this, specifically: I am running perl version 5.005_03 built for AIX Unix. I have Oracle version 8.1.7 installed and running. I have AIX version 4.3.3.0 I have installed the DBI and DBD::Oracle modules... I am able to execute queries and PL/SQL blocks using these modules with no problems. What I'd like to do is read a file that contains DDL statements and execute them through these modules. These files contain specifically CREATE TABLE statements CREATE INDEX statements CREATE PACKAGE/PACKAGE BODY statements CREATE trigger statements CREATE VIEW statements In some cases, these files have more than one statement in them. (example, creating several indexes on a table)... These are taken from PVCS Version manager and I would like to be able to run them in one session and show the output (that is, if compilation or creation fails). I've searched the DBI and DBD documentation and I've not found anything that specifically addresses this. I tried running one CREATE TABLE statement and it appears to choke on some keywords that Oracle has no trouble with, but I suspect has to do with the fact that they are not necessarily ANSI-SQL compliant. Can anyone help out?
