Home » Open Source » Programming Interfaces » Perl DBI and interactive SQL script
Perl DBI and interactive SQL script [message #34982] Fri, 14 January 2005 07:01
Messages: 164
Registered: April 1999
Senior Member

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 ?
Previous Topic: Connect PHP to Oracle9i
Next Topic: connect to oracle9i to php 5.0 on iis on win xp
Goto Forum:

Current Time: Wed Apr 24 03:50:54 CDT 2024