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!

Using variable as table name in pl/sql query - Is possible?

450140Aug 14 2005 — edited Aug 15 2005

I am relatively new to PL/SQL and I am trying to create a function that accepts a table name and a rowid as arguments and returns a comma-delimited record string of the values of the table/rowid being passed. The problem is , I cannot code a select stmt as follows

SELECT * FROM v_table_name
WHERE rowid = v_row_id

in PL/SQL. There must be a easy way to approach this.
Thanks for any and all advice.

GC

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 12 2005

Added on Aug 14 2005

6 comments

1,809 views