Re: Proceeding table object as procedure argument

THX, yes dynamic SQL helps in this case but the original question still stays; can I pass the table as an object to PL/SQL procedure for other manipulation?

--

Stjepan Brbot


"Tom Best" <oracle_person_at_yahoo.com> wrote in message
news:ahjh41$9n7$1_at_news.bentley.com...


> Stjepan:

>

> Use dynamic SQL.  Create the SQL statement as a string, concatenating

the


> parameters containing the table/column names.  Something like this:

>

> sql_statement := 'update ' || p_tablename || ' set ' || p_columnname

|| ' =


> ''' || p_someval || '''';

> execute immediate sql_statement;