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!

EXECUTE IMMEDIATE PACKAGE DDL: PLS-00103: Encountered the symbol "/"

784197Aug 20 2010 — edited Aug 20 2010

Hi all,

I am using Dynamic PL/SQL to update and recreate a PACKAGE and I have the following error while using EXECUTE IMMEDIATE on the GET_DDL:

Case 1:
With SQLTERMINATOR set to TRUE, GET_DDL inserts a / between PACKAGE SPEC and BODY and I have the following error when I try to EXECUTE IMMEDIATE this DDL:

PLS-00103: Encountered the symbol "/"

Case 2:
With SQLTERMINATOR set to FALSE, EXECUTE IMMEDIATE encounters CREATE immediately after the end of PACKAGE SPEC and I have the following error.

PLS-00103: Encountered the symbol "CREATE"

What is the correct way to GET_DDL of a PACKAGE inorder to use with EXECUTE IMMEDIATE?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2010

Added on Aug 20 2010

4 comments

1,622 views