Hi all,
How to call or execute a script(containing only SQL statements) from a PL/SQL block.
Thanks in advance.
Printable View
Hi all,
How to call or execute a script(containing only SQL statements) from a PL/SQL block.
Thanks in advance.
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.
I think your problem could solve using external libraries
why call external scripts, put the sql query/or create corresponding procedure and call from inside dbms_sql.
gpsingh,
You are right but Hakimca is asking to call script file.
You can't execute script file thru dbms_sql package