in reply to DBI & Oracle Command Files

Is the @OBFX001S bit what you'd use in SQL*Plus to execute the command file?

If so then this will not work - because DBI isn't SQL*Plus, and SQL*Plus has a number of addition features on the client side that will (presumably) run the command file.

If the command file is a collection of SQL statements then you have to open the file in perl and parse it so that you can execute each of the SQL statements individually.

Michael

Replies are listed 'Best First'.
Re: Re: DBI & Oracle Command Files
by Ronnie (Scribe) on Aug 20, 2003 at 08:56 UTC
    Thanks you're absolutely correct & I feel ever so humble for not realising that! (I think I'm lucky still to be within the monastery for asking such a foolish question!) Cheers, Ronnie