Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Proceeding table object as procedure argument
How can I send table (object) to database PL/SQL procedure as an
argument? For example I'd like to create generic procedure accepting the
table (object) for updating one column in that table with particular
value. Of course, every table sent to this procedure should have the
same column.
This procedure should execute DML like this where 'tablename' is the table (object) sent as argument to this procedure:
UPDATE tablename.column SET 'xyz';
-- Stjepan BrbotReceived on Tue Jul 23 2002 - 03:20:38 CDT