Connecting Tech Pros Worldwide Forums | Help | Site Map

How do you call an external script using DBI

Newbie
 
Join Date: Nov 2008
Posts: 3
#1: Nov 25 '08
I started by posting here but realized that may not have been the correct place to post.

I'm looking for a way to call an external sql script using DBI, DBD, or Oraperl. Sqlplus dies on windows after 64 calls (windows fork error) so I'm searching for a way to call it outside of a system call.

I thought about parsing the file, but why re-invent the wheel? If there is something out there that works I would like to know about it, rather then making a mess of my code.

I tried @name.sql, exec, start, run, source, and calling the script name outright, but none of them worked for me, and I can't find one single reference to a strictly SQL way to execute a script.

Member
 
Join Date: Oct 2008
Location: Home
Posts: 127
#2: Nov 25 '08

re: How do you call an external script using DBI


Hi,

I looked around a bit, but everyone says, it's not possible. As SQLplus crashes, you are stuck with either parsing the file or writing a pl/sql procedure, you can invoke from dbi, to execute the file for you.

Pilgrim.
Newbie
 
Join Date: Nov 2008
Posts: 3
#3: Nov 25 '08

re: How do you call an external script using DBI


Thanks for the response. Its not what I wanted to hear, but that's life :-)

Joe
Reply

Tags
dbi, oracle, oraperl, script, sql


Similar Oracle Database bytes