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!

Create a script to create multiple objects without using execute immediate.

758989Mar 9 2010 — edited Mar 9 2010

I have a function that requires several objects (4 types, 8 functions) to run. Right now they're in separate sql files. I'd like to combine them into one file that I would run but I'd rather not use the 'execute immediate' since it seems like you have to escape quotes and the like.

How would you do that?

Thanks in advance,

J

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2010

Added on Mar 9 2010

#multiple, #script

2 comments

560 views