KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a procedure like : CREATE OR REPLACE PROCEDURE test is BEGIN DBMS_OUTPUT.PUT_LINE('This is a Test'); END; I want to run some sql scripts stored in the current directory. I could run them from sqlplus with '@scriptname.sql' but how can i do it from inside the procedure ? For ex: CREATE OR REPLACE PROCEDURE test is BEGIN DBMS_OUTPUT.PUT_LINE('This is a Test'); @scriptname.sql END; This doesn't seem to work ! Is there a specific to run sql scripts from pl/sql procedures ?
Tags (comma-separated)
Save Edits
Cancel