Stored Procedures

Can I pass a datatype of record to a stored procedure?

Here is my record declaration from calling program:

TYPE StandardType is Record

 (product      varchar2(10),
  pn           varchar2(10),
  T1           number,
  T2           number);

Price_rec      StandardType;

Stored Procedure specification:

Create procedure TEST (Price_Rec StandardType) AS

end;
/

When I try to compile the stored procedure I get an error saying StandardType must be defined (I also tried "Record" as the data type - no go).

Thanks for any info.

M. Landa Received on Mon Jan 09 1995 - 19:02:54 CET