Colons on SQL passed to oraperl
Date: Tue, 1 Jun 1993 17:17:46 GMT
Message-ID: <1993Jun1.171746.1586_at_infodev.cam.ac.uk>
I have a problem with oraperl, which I am posting here both because I have lost Kevin Stock's e-mail addres and because it might be of more general interest.
I am using version 2.3 of oraperl linked with Oracle 7.0.12.
I am attempting to develop a source control system for Oracle 7 stored procedures, packages, triggers etc, using oraperl. As part of this enterprise, I have a bit of oraperl which slurps an entire file and passes it to Oracle as a single SQL statement (using &ora_do). These statements start with CREATE OR REPLACE PACKAGE BODY or some such, and may be quite long.
Everything works just fine provided the statement contains no colons. However, if there is a colon in the file at all, oraperl tries to process it as if it introduced a bind variable. This applies even if the colon is followed by an equals sign (making a PL/SQL assignment operator)!
Surely, bind variable processing should only be applied to DML statements, not DDL statements.
So, I am stuck. Does anyone know a way of turning off bind variable processing in &ora_do?
Charles Jardine - University of Cambridge Computing Service. cj10_at_ucs.cam.ac.uk Received on Tue Jun 01 1993 - 19:17:46 CEST