Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best way to Run sql script inside a plsql block

AshokramJul 3 2015 — edited Jul 3 2015

Hi all

Thanks in Advance.

I have a requirement in that I have to run a SQL Script ( which is in OS Directory)  from a Procedure.

Shall I Use UTL_FILE package and EXECUTE Immediate or any other simple way is there ???

Kindly Help me

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2015
Added on Jul 3 2015
16 comments
4,767 views