Mathieu, Sure, you can run the SQL statements in your file with DBI, but you will need to parse the file to get all the SQL statements and then run them through the DBI interface. I would suggest that if you need to use Perl/DBI, that you instead look at a different method than running the SQL statements from the file, parsing the individual SQL statements, and instead look at possibly using the Class::Phrasebook and Class::Phrasebook::SQL modules from CPAN.
The number of SQL statements is not significant with Perl/DBI. The following will be your output issues: 1. All spool statements will turn to Perl print() calls. 2. Any PL/SQL dbms_output calls will need to be handled with the DBD::Oracle calls to enable dbms_output. You will need to: 1. Read the Perl docs to get familiar with the syntax of the language. 2. Read and understand the DBI docs (perldoc DBI). 3. Read and understand the DBD::Oracle docs (perldoc DBD::Oracle). Hopefully, I have not clouded the issue for you. ----------------- Ron Reidy Senior DBA Array BioPharma, Inc. -----Original Message----- From: Mathieu Barbeau [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 2:08 PM To: [EMAIL PROTECTED] Subject: Question with DBI versus PERL Hi, I have a really big sql scripts with many select, procedures and spool spool off statements. I want to know how can i run this sql script with DBI. With sqlplus, this sql script run correctly. But I don't know how can i run this script with perl. Can you help me? This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
