|
Replies:
6
-
Pages:
1
-
Last Post:
Apr 13, 2011 4:24 AM
by: prawin62
|
|
|
|
|
|
|
Bug while executing the stored procedure
Posted:
Apr 12, 2011 9:39 PM
|
|
|
|
|
|
Posts:
7
Registered:
4/5/11
|
|
|
|
Bug while executing the stored procedure
Posted:
Apr 12, 2011 9:39 PM
in response to: Guest
|
|
|
|
|
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
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Bug while executing the stored procedure
Posted:
Apr 12, 2011 11:04 PM
in response to: prawin62
|
|
|
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.
|
|
|
Posts:
7
Registered:
4/5/11
|
|
|
|
Re: Bug while executing the stored procedure
Posted:
Apr 13, 2011 12:25 AM
in response to: Mauritz
|
|
|
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
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Bug while executing the stored procedure
Posted:
Apr 13, 2011 3:16 AM
in response to: prawin62
|
|
|
In the options dialog.
/Henrik
|
|
|
Posts:
7
Registered:
4/5/11
|
|
|
|
Re: Bug while executing the stored procedure
Posted:
Apr 13, 2011 4:04 AM
in response to: Mauritz
|
|
|
Thanks for your reply its working fine now
~Praveen
|
|
|
Posts:
7
Registered:
4/5/11
|
|
|
|
Re: Bug while executing the stored procedure
Posted:
Apr 13, 2011 4:24 AM
in response to: Mauritz
|
|
|
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)
|
|