Re: Proceeding table object as procedure argument

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 23 Jul 2002 19:45:24 +0200
Message-ID: <3g5rjucmt06niqbslr9akjhlb9vfiaurm3@4ax.com>

On Tue, 23 Jul 2002 10:20:38 +0200, "Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote:

>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';

Tom Best provided a correct answer. Please note you are going to have hard parses all over the place and you will end up with a non-scalable application.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 23 2002 - 12:45:24 CDT