Oracle Database Discussions

I need to do a select from a table that is unknown until runtime. Is there any good examples of this. The Store Procedure will take in the table name and return a row.

I am not using inline SQL because there is a lot more complexity involved . What I need to do is understand how to reference this unknown table.


Here is an example of what I have written so far.

PACKAGE pk_LoadNativeDataItems IS

PROCEDURE version;

TYPE RowDataCur IS REF CURSOR;

PROCEDURE pr_LoadNativeDataItems(p_flag IN NUMBER
p_how_many_rows_to_fetch IN NUMBER,
p_row_data OUT RowDataCur);


PROCEDURE pr_LoadNativeDataItems(p_flag IN NUMBER
p_how_many_rows_to_fetch IN NUMBER,
p_table_name IN VARCHAR,
p_row_data OUT RowDataCur) IS


BEGIN
OPEN p_row_data FOR
SELECT * from ||p_table_name||;
END pr_LoadNativeDataItems;

END pk_LoadNativeDataItems;

Thanks for any help

Tony