PDA

Click to See Complete Forum and Search --> : Please Help

Hakimca
03-26-2001, 10:19 AM
Hi all,

How to call or execute a script(containing only SQL statements) from a PL/SQL block.

Thanks in advance.
m1l
03-27-2001, 08:04 AM
As far as I know, you can't call scripts in PL/SQL. You could put your scripts as database procedures and then you could call them.
Kancha
03-27-2001, 12:35 PM
I think your problem could solve using external libraries
gpsingh
03-27-2001, 01:13 PM
why call external scripts, put the sql query/or create corresponding procedure and call from inside dbms_sql.
Kancha
03-27-2001, 02:38 PM
gpsingh,

You are right but Hakimca is asking to call script file.
You can't execute script file thru dbms_sql package