select from Index-By Table in a package has errors [message #347888] |
Sun, 14 September 2008 23:32  |
soidamientrung
Messages: 2 Registered: September 2007 Location: HCM
|
Junior Member |
|
|
I have a package as following. I want to select data from an Index-By Tabe in my package. But It has error.
Please, can you have me!
CREATE OR REPLACE PACKAGE TN_MUSIC_HaiTest AS
type myTableType is table of number(4);
PROCEDURE P_Test_indexby_table(
p_P1 IN myTableType,
p_curResult out SYS_REFCURSOR
);
END TN_MUSIC_HaiTest;
/
CREATE OR REPLACE PACKAGE BODY TN_MUSIC_HaiTest AS
PROCEDURE P_Test_indexby_table(
p_P1 IN myTableType,
p_curResult out SYS_REFCURSOR
) AS
--t_empnos myTableType := myTableType(7639,7344,7654);
BEGIN
OPEN p_curResult FOR
SELECT column_value as C1
from table(cast(p_P1 as myTableType));
--from table(cast(t_empnos as myTableType));
END P_Test_indexby_table;
END TN_MUSIC_HaiTest;
/
|
|
|
|
|