Hi lesstjm,

DBMS_OUTPUT.PUT_LINE doesn't accept a variable of type CURSOR - that's why you got the eror message. You have to pass to this procedure the result of the fetching (a number, varchar or date...), not the cursor itself.

Regards,