| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Referring to cursor values with dot notation
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
![]() |
![]() |