Forums » General Discussion

Thread: Bug while executing the stored procedure


Permlink Replies: 6 - Pages: 1 - Last Post: Apr 13, 2011 4:24 AM by: prawin62
Guest
Bug while executing the stored procedure
Posted: Apr 12, 2011 9:39 PM
  Click to reply to this thread Reply




prawin62

Posts: 7
Registered: 4/5/11
Bug while executing the stored procedure
Posted: Apr 12, 2011 9:39 PM   in response to: Guest
  Click to reply to this thread Reply
Attachment image003.png (10.7 K)

 

Hi,

 

 

I have executed the procedure script directly from the Database Explorer but I am getting all out values as ?excluded?.

 

I am getting the same when I use ?Call StoredProcedure(parameters)? syntax. 

 

 

 

 

When I tried same syntax(?Call StoredProcedure(parameters)?) in ?MYSQL query browser' its working fine. Is this a bug in toad?

 

Thanks,

Praveen

 




Mauritz

Posts: 313
Registered: 8/23/07
Re: Bug while executing the stored procedure
Posted: Apr 12, 2011 11:04 PM   in response to: prawin62
  Click to reply to this thread Reply

First thing is to make sure "Read LOBs when initially fetching data" option is enabled (It's under "Database|General". Also if you don't expect BLOB data here and that is what you are getting please try the 6.0 beta because it should fix that issue.



prawin62

Posts: 7
Registered: 4/5/11
Re: Bug while executing the stored procedure
Posted: Apr 13, 2011 12:25 AM   in response to: Mauritz
  Click to reply to this thread Reply

Hi Mauritz,

I am new to toad for my sql

I didn't find "Database|General". could you please tell me where can I find that?

Thanks
Praveen


Mauritz

Posts: 313
Registered: 8/23/07
Re: Bug while executing the stored procedure
Posted: Apr 13, 2011 3:16 AM   in response to: prawin62
  Click to reply to this thread Reply

In the options dialog.

/Henrik


prawin62

Posts: 7
Registered: 4/5/11
Re: Bug while executing the stored procedure
Posted: Apr 13, 2011 4:04 AM   in response to: Mauritz
  Click to reply to this thread Reply

Thanks for your reply its working fine now




~Praveen





prawin62

Posts: 7
Registered: 4/5/11
Re: Bug while executing the stored procedure
Posted: Apr 13, 2011 4:24 AM   in response to: Mauritz
  Click to reply to this thread Reply

Hi Maurutz,

I have tried with 6.0.0. beta version also, in that I am not getting the script result tab

where can i find that?


Thanks
Praveen




Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums