PL/SQL tables

From: <ironbeak_at_hotmail.com>
Date: Fri, 26 Nov 1999 18:08:23 GMT
Message-ID: <81mial$m0n$1@nnrp1.deja.com>

I am using Oracle 7. For the parameters to a PL/SQL procedure I can set varchar2, pls_integer, etc to default NULL so I don't have to pass that parameter to the procedure. Is there a equivilent for the table datatype or a way to get the same behavior? If yes, how do I do this?

for example in

procedure test (

iprocID in varchar2 default NULL <-- anyway to do this for

a                                                  table

);

Any answer (yes/No) would be appreaciated.

Thanks for your time
Jan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 26 1999 - 12:08:23 CST