How to view a CLOB Output parameter returned from a procedure in DB2 control Center?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • somadritadas23
    New Member
    • Aug 2010
    • 2

    #1

    How to view a CLOB Output parameter returned from a procedure in DB2 control Center?

    How to view a CLOB Output parameter returned from a procedure in DB2 control Center(DB2 9.5).I have a procedure ABC having an output parameter ORET of CLOB datatype.This is ideally a long sql query which is formed after various conditions.But when I call the procedure the output comes as "Parameter Name : ORET, Parameter Value : - ".So how to view this output?
Working...