Hi,

As a newbie, I'm feling slightly proud of my efforts so far.

The majority of which is, I'm afraid, simply example filched from the
O'Reilly Perl-DBI book (thanks Alligator(?) & Tim)

However, one thing I cannot seem to do is run a (supplied by the Oracle DBA)
sql script... I've tried ->do, I've tried the 4-step prepare, execute,
finish, fetch, deallocate but the same error message occurs.. ORA-00900
(invalid SQL)

Heres a brief example....

$rows = $dbh->do("\@/home/bill/sql/run.sql");

I also tried "@....run.sql" & "run .../run.sql" with no joy

As I said, the O'Reilly book IS superb - but all it gives me in this
instance is a "How to call a PL/SQL procedure"

Any tips/hints/help/advice please, please, please folks?

Thanks

Bill


Reply via email to