select record type

From: Anil G <anil.gothal_at_gmail.com>
Date: 10 Aug 2006 16:14:54 -0700
Message-ID: <1155251694.108909.261100@h48g2000cwc.googlegroups.com>

I have package specification having TYPE as TYPE some_rec IS RECORD(
col1 varchar2(100),
col2 varchar2(100)
);

TYPE some_ntbl IS TABLE OF some_rec;

..........

And i have Package Body some function trying to do following:

v_some_ntbl some_ntbl := som_ntbl();
....

SELECT some_rec(
tbl.col1,
tbl.col2
)
BUILK COLLECT INTO v_some_ntbl
FROM tableCol tbl

Some how oracle does not recognize record types, I am aware that this can be done with Pure Object types, but those requires additional maintainance.

Let me know,

Thanksm
Anil G Received on Thu Aug 10 2006 - 18:14:54 CDT