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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

550 views