Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Proceeding table object as procedure argument
Either dynamic SQL is your answer, or you are not explaining yourself
clearly. The subject title itself is confusing. Maybe you are thinking
about passing 'objects' as arguments. Tom Kyte has a very detailed
demo on nested table at this link
"Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message news:<ahlq99$f0lm$1_at_as201.hinet.hr>...
> 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;
Received on Wed Jul 24 2002 - 17:26:07 CDT