dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

How do I use TOAD to display CLOB IN OUT param from a stored procedure - Oracle Tools

This is a discussion on How do I use TOAD to display CLOB IN OUT param from a stored procedure - Oracle Tools ; hi I have a sp in oracle 9i ver which have CLOB IN OUT param, when I execute this sp using toad editor it shows "procedure successfully exceuted" but can't see the result. here is proc PROCEDURE Test(io_clob IN OUT ...


Home > Database Forum > Oracle Database > Oracle Tools > How do I use TOAD to display CLOB IN OUT param from a stored procedure

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-22-2008, 11:53 AM
Database Newbie
 
Join Date: Oct 2008
Posts: 1
bbanik07 is on a distinguished road
Default How do I use TOAD to display CLOB IN OUT param from a stored procedure

hi
I have a sp in oracle 9i ver which have CLOB IN OUT param, when I execute this sp using toad editor it shows "procedure successfully exceuted" but can't see the result. here is proc
PROCEDURE Test(io_clob IN OUT CLOB) IS
xmlclob CLOB;
BEGIN
--populate the xml from database and return it to xmlClob
io_clob := xmlclob;
END;

Thanks
Reply With Quote
  #2  
Old 11-28-2009, 04:17 PM
Database Newbie
 
Join Date: Oct 2009
Location: India
Posts: 19
giteshtrivedi is on a distinguished road
Default Re: How do I use TOAD to display CLOB IN OUT param from a stored procedure

Contains of CLOB can get from toad using output property. You can get contain of CLOB is totally depending on TOAD version. Check output property for CLOB contain.
__________________
Thanks and Regards,
Gitesh Trivedi
Dbametrix Solutions
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 12:04 AM.