-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|