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!

How to pass dynamically table name in my cursor declaration

530678Aug 29 2006 — edited Sep 5 2006

Hi:
I am new. could you please let me know how to pass a table name dynamically in my cursor declaration? for instance I am declaring the following cursor in my pl/sql procedure:

CURSOR crs_validate IS
select * FROM <ACT_JUN_2006_LOB>;

this ACT_JUN_2006_LOB table name, I should able to pass it when I open the cursor ... any help appreciated. thanks.
srini

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2006

Added on Aug 29 2006

8 comments

5,269 views