Analytics Software

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!

ODI 12c: Error while passing sequence name using variable into a package

2782749Aug 17 2015 — edited Aug 17 2015

I am passing a sequence name in a package to reset sequence value where one parameter is the sequence name and sequence start value. Now when i am passing a default value like 'W_Customer_SEQ' the package is working when i am passing W_Customer_SEQ without the quote the package isn't working. Now i am concatenating the table name and _SEQ in one variable and passing that variable into the package. in this case i am getting the following error:

ORA-06550: line 2, column 50:

PLS-00357: Table,View Or Sequence reference 'W_Customer_SEQ' not allowed in this context

ORA-06550: line 2, column 2:

PL/SQL: Statement ignored

06550. 00000 - "line %s, column %s:\n%s"

*Cause: Usually a PL/SQL compilation error.

This is the same error i am getting when i am passing the default value without quote.

So, it seems the variable isn't resolving into the sequence name with quote.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2015

Added on Aug 17 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

0 comments

312 views