If I have a record declared in the body of my package for the purposes of passing records instead of variables as parameters, must I also declare the record in the spec. I seem to be getting an error that makes me believe that I need to declare it in the spec as well as the body.
The error was PLS-00201. params_rec must be declared
my record in the body is this:
TYPE PARAMS_REC IS RECORD(
must it also go in the spec? Things don't need to be declared in the spec unless I want them public right?
This is from the SPEC and is the procedure I want to pass the record variables to:
P_PARAMS_REC PARAMS_REC; --THIS ISN'T WORKING
); --DROPS PRE-EXISTING TABLES