Thanks for the question, Priyanka.
Asked: October 08, 2018 - 12:48 pm UTC
Last updated: October 11, 2018 - 3:56 am UTC
Version: 12
Viewed 1000+ times
You Asked
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.
and Connor said...
You didn't really give us much context :-(
All we can say is ... it works for us
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
Is this answer out of date? If it is, please let us know via a Comment