Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_OUTPUT.PUT_LINE dos not display anything

Hi,
I have a PL/SQL procedure with cursor. I want to display the values of variables.
DBMS_OUTPUT.PUT_LINE(dummy_unit_pk);
First, the line appear greyed.
Secondly, nothing is displayed. I have executed set serveroutput on.
Thirdly, if I put 2 variables on the statement like this i get an error message.
DBMS_OUTPUT.PUT_LINE(dummy_unit_pk, dummy_ident_pk);
Erreur(67,1): PLS-00306: numéro ou types d'arguments erronés dans appel à 'PUT_LINE'
Best regards.
Christian

Comments
Post Details
Added on Sep 10 2021
6 comments
2,020 views