PLS-00488: invalid variable declaration: object 'SHARED_REC' must be a typ
Rich VJan 15 2010 — edited Jan 15 2010Hello,
I need to pass a plsql table as IN parameter for a procedure which is part of a Package. So, I did following in package spec.
CREATE OR REPLACE PACKAGE APPS.cxs_source
AS
TYPE type_shared_rec IS RECORD (
total_indexes NUMBER,
total_tables NUMBER,
grand_total NUMBER,
idx_lagnum_diff NUMBER,
idx_percentincr NUMBER,
tbl_lagnum_diff NUMBER,
tbl_percentincr NUMBER,
tablekount NUMBER,
indexkount NUMBER
);
TYPE shared_batch IS TABLE OF type_shared_rec
INDEX BY BINARY_INTEGER;
shared_rec shared_batch;
procedure generateUTL(p_dir_path in varchar2,
passTable shared_rec);
But I am getting PLS-00488 error as mentioned in subject line.
Where am i doing wrong?
I am using Oracle 9i EE.
Thanks,
R