Does anyone know if DBI can cater for the running of a locally held query? If I have a file called fred.sql in my local directory which contains various SQL commands. I would execute this file as @fred. In DBI I prepare this file - with the preceding Perl escape character - and this goes fine. The DBI execute fails with -
DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD ERROR: OCI StmtExecute) at DBI_connect.org line 544. DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD ERROR: OCI StmtExecute) at DBI_connect.org line 544. Running the file as @fred works fine from SQLPLUS - can this be done using DBI? Cheers, Ronnie PS I've discovered that any locally held file produces the same error so I presume it's an error on my part somewhere!
