SQL & PL/SQL

Hi all,

on 11.2.0.4,

I have a table :

SQL> desc details

Name Null? Type

----------------------------------------- -------- ---------------

EMPRUNT NOT NULL NUMBER(10)

NUMERO NOT NULL NUMBER(3)

ISBN NUMBER(10)

EXEMPLAIRE NUMBER(3)

RENDULE DATE

This query returns some rows :

But when I want to use that in a PL/SQL I have nothing :

set serveroutput on

Declare

nombre_emp number(10);

 CURSOR C\_EMP Is

 SELECT isbn

INTO nombre\_emp

FROM details

group by isbn

;

Begin

 DBMS\_OUTPUT.ENABLE( 1000000 ) ;

 For C in C\_EMP Loop

    DBMS\_OUTPUT.PUT\_LINE( 'MCNT -> ' || nombre\_emp ) ;

    DBMS\_OUTPUT.NEW\_LINE ;        

 End loop ;

End ;

/

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

MCNT ->

PL/SQL procedure successfully completed.

Thanks for help.