Perl DBI and interactive SQL script [message #34982] |
Fri, 14 January 2005 07:01 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Hi,
I've received a large and complex file which is intended to be run interactively through Oracle 8i SQLPLUS. When it runs, it prompts for user input.('ACCEPT').
I'm trying to get a Unix-Perl script to call this file but the variable I'm using is always ignored by the SQL-file, that is, the file which collects the output contains the prompt only. This has happened with DBI and also calling SQLPLUS inline from the perl script. Can anybody help ?
|
|
|