Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Cast+Select from pl/sql table question

Cast+Select from pl/sql table question

From: Andor Gyula <gy.andor_at_euromacc.hu>
Date: Thu, 25 Jan 2001 12:55:23 +0100
Message-Id: <10752.127462@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US