Re: passing PL/SQL tables of different types into a procedure

From: Rich Richardson <therichardsons_at_tdi.net>
Date: Fri, 19 Jun 1998 11:06:44 -0400
Message-ID: <358A7E84.1B0@tdi.net>

Rich wrote:

You can accomplish something like that using the DBMS_SQL package. This allows you to write sql statement containing wildcards for fields. Oracle will not force the validation of the table using this package.

Rich.

Paul wrote:
>
> Hi,
>
> I have a procedure (oracle 8) which accepts a PL/SQL table of a certain
> type (using %rowtype from an SQL table) as a parameter.
>
> but it would be nice if this procedure could be general enough to use
> with tables of different types, is there any way to do this? I guess
> what I'm looking for is something that would be like a general table
> type, analogous to a void pointer in C perhaps? any suggestions, or
> ideas as to how this could be done differently?
>
> thanks,
> Paul
Received on Fri Jun 19 1998 - 10:06:44 CDT