plsql script does not return anything

Question

plsql script does not return anything

Navigation

#1 by (0 votes)

0

I have a problem with this script since I have the database full but when executing the following the courses do not return anything

DECLARE
 CURSOR VA_QUERY IS
    SELECT Business_Area_Cd , Business_Area_Name FROM EXMCPRA.BUSINESS_AREA;

 SALIDA VA_QUERY%ROWTYPE;

BEGIN
 OPEN VA_QUERY;
        FETCH VA_QUERY INTO SALIDA;      
         dbms_output.put_line (SALIDA.Business_Area_Cd || ',' || SALIDA.Business_Area_Name );
 CLOSE VA_QUERY;

END;

oracle oracle-sqldeveloper plsql

asked by Cristopher Vergara 25.04.2017 в 16:25

source

1 answer

Web system security issues Problem with: "String was not recognized as a valid DateTime."

score 0 · Answer 1

Try with:

DECLARE
 CURSOR VA_QUERY IS
    SELECT Business_Area_Cd , Business_Area_Name FROM EXMCPRA.BUSINESS_AREA;

 SALIDA VA_QUERY%ROWTYPE;

BEGIN
 OPEN VA_QUERY;
 LOOP
        FETCH VA_QUERY INTO SALIDA; 
        EXIT WHEN VA_QUERY%NOTFOUND;        
            dbms_output.put_line (SALIDA.Business_Area_Cd || ',' || SALIDA.Business_Area_Name );
 END LOOP;
 CLOSE VA_QUERY;

END;