How should Oraperl execute .sql file? 1

[azarko]

I have Perl 5, and I use Oraperl to connect to Oracle 8i. I have no problem executing one command per line using

&ora_do($lda, 'drop table myTable');

However, command

&ora_do($lda, '@myFile.sql');

and

&ora_do($lda, '@/absolut/path/myFile.sql');

are just silently ignored. What should I do?
Thanks for help in advance

 

[AndyBo]

Have you looked at the DBI and DBD::Oracle modules? You may find these easier to use than oraperl.

Alternatively, load the .sql file into an array and try passing that as an argument to the ora_do command. For example:
[tt]
open(SQLFILE, &quot;</path/to/some.sql&quot;
@SQL_Array = <SQLFILE>;
close(SQLFILE);
&ora_do($lda, @SQL_Array);
[/tt]