Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> passing PL/SQL tables of different types into a procedure

passing PL/SQL tables of different types into a procedure

From: Paul <pauld1_at_hotmail.com>
Date: Thu, 18 Jun 1998 15:58:06 GMT
Message-ID: <35893787.976146D9@quarry.com>


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 Thu Jun 18 1998 - 10:58:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US