Error executing Cursor

Question

Error executing Cursor

Navigation

#1 by (1 votes)
#2 by (1 votes)

0

When I execute the next SQL block, it tells me that I must declare the variable p_name, but I have declared it before.

declare
p_nombre varchar2(200) ;
BEGIN

    FOR REG IN (select c1000 INTO p_nombre 
        from edyficar.cl_clientes2 
        where cod_seg_mor = 1 and cod_seg_cob = 9 and c8421 = 'S' and segmentacion = 'C1' )
    LOOP
        dbms_output.put_line(REG.p_nombre);
    END LOOP;
END;

oracle plsql

asked by Carlos Cortez 17.04.2017 в 07:39

source

2 answers

Do not load the scripts from the BundleConfig.cs Report viewer does not show the report when it runs on the server, but does it in local mode

score 1 · Answer 1

Try with:

DECLARE
CURSOR cursor_nombre is 
    select c1000 
    from edyficar.cl_clientes2 
    where cod_seg_mor = 1 
    and cod_seg_cob = 9 
    and c8421 = 'S' 
    and segmentacion = 'C1';
BEGIN
    FOR REG IN cursor_nombre
    LOOP
        dbms_output.put_line(REG.c1000);
    END LOOP;
END;

score 1 · Answer 2

The error is due to reg.p_nombre that you have not declared. Actually, the problem is that you are trying to use the implicit cursor syntax (very well), but mixing it with the syntax of SELECT ... INTO (bad).

The correct way to use the implicit cursors is the following (note that in the correct way, you do not even need to declare the variable p_nombre :

BEGIN
    FOR REG IN (select c1000
        from edyficar.cl_clientes2 
        where cod_seg_mor = 1 and cod_seg_cob = 9 and c8421 = 'S' and segmentacion = 'C1' )
    LOOP
        dbms_output.put_line(REG.c1000);
    END LOOP;
END;