SteveCulshaw
Programmer
I'm trying to get to grips with using stored procedures, and already I'm baffled :-(
I thought it'd be sensible to set a default date
....
PROCEDURE GetValidBCApp(
o_CaseNo OUT tblCASENO,
o_RefVal OUT tblREFVAL,
o_Address OUT tblADDRESS,
i_From IN tblDECIDD DEFAULT '01-JAN-00',
i_Until IN tblDECIDD)
IS
....
but I get a PLS-00323 error.
Just what is the syntax for setting default ??
Thanks, Cheers,
Steve C.
I thought it'd be sensible to set a default date
....
PROCEDURE GetValidBCApp(
o_CaseNo OUT tblCASENO,
o_RefVal OUT tblREFVAL,
o_Address OUT tblADDRESS,
i_From IN tblDECIDD DEFAULT '01-JAN-00',
i_Until IN tblDECIDD)
IS
....
but I get a PLS-00323 error.
Just what is the syntax for setting default ??
Thanks, Cheers,
Steve C.