procedure having out parameter of clob type, how we will see the value of it,please advise?

Hello Tom,

we are having one procedure as below:

PROCEDURE P1
(
p_dat_file_name out varchar2,
p_zip_file_name out varchar2,
p_metadata_clob out clob,
p_status OUT VARCHAR2,
p_message OUT VARCHAR2
)
AS
BEGIN
END P1;

while running this procedure p1, we are getting output for p_dat_file_name,p_zip_file_name ,p_status & p_message out parameters but we are not getting output for p_metadata_clob of clob type.neither p_metadata_clob is coming in output window. Therefore, how could i see the output of p_metadata_clob? Please advise.

Thanks.

SQL> create or replace
  2  procedure P(n out int, c out clob) is
  3  begin
  4    n := 1;
  5    c := 'Hello';
  6  end;
  7  /

Procedure created.

SQL>
SQL>
SQL> variable nnn number
SQL> variable ccc clob
SQL>
SQL> exec p(:nnn,:ccc);

PL/SQL procedure successfully completed.

SQL>
SQL> print nnn

       NNN
----------
         1

SQL> print ccc

CCC
---------------------------------------------------
Hello