Sachin Srivastava wrote:Toad is not an Oracle product, to get help with Toad try
requirement is to show the value in refcursor at toad and how to pass the above value in CLOB.
any sugestion welcome .. Thanks in advance
Sachin Srivastava wrote:Looks like bad design. Why are you passing multiple values in an atomic datatype?
I am executing the below code in Toad. I want to pass the value in CLOB
Value will be of
I_ITEM_NO := '01234567/01234568/01234569/.... up to 100 reoccurnces.
requirement is to show the value in refcursor at toad and how to pass the above value in CLOB.Refcursors don't store values, so you can't show values in a refcursor.