Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Cast+Select from pl/sql table question
Hi Gurus !
Is there any way to use "select" on PL/SQL tables? I tried it the way below but is doesn't work. What's wrong?
CREATE OR REPLACE PROCEDURE TESTPROC IS
Type T_REC is record (AN NUMBER, B Varchar2(1));
Type test is table of T_REC;
V_TEST TEST;
V_NUM NUMBER;
BEGIN
select CAST(V_TEST.AN as NUMBER) into V_NUM from table(v_test);
END TESTPROC;
Received on Thu Jan 25 2001 - 05:55:23 CST
![]() |
![]() |