How do you call an external script using DBI

[FiremanJoe]

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.

[Pilgrim333]

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.

[FiremanJoe]

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

Joe