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

Home -> Community -> Usenet -> c.d.o.server -> Referring to cursor values with dot notation

Referring to cursor values with dot notation

From: Steven Moyano <stevem_at_nwu.edu>
Date: 1997/02/28
Message-ID: <5f7h8t$kpi@news.acns.nwu.edu>#1/1

Is there anyway to refer to a column in the cursor by the cursor name, for use in an insert statement? The follow raises the PLS-00225: subprogram or cursor 'C' reference is out of scope message. The cursor is declared between the AS and BEGIN of the create procedure statement, and the OPEN C; statement does not fail, perhaps suggesting that the location within the block structure is not the problem.

Thanks very much for your time and help.

        CURSOR C IS 
        SELECT * 
        FROM TABLE1;

INSERT INTO TABLE2 (FIELD1, FIELD2)
VALUES (C.FIELD1, C.FIELD2);                          Steven Moyano
Northwestern University, Evanston, IL. USA stevem_at_nwu.edu Received on Fri Feb 28 1997 - 00:00:00 CST

Original text of this message

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