Executing a Stored procedure - Issue

SQL Navigator
1

When I use Execute procedure wizard in SQL Nav, the procedure never runs just gives error message in the ouput window “No closing quote character”
I have tried evertying to remedy but it looks like its a problem with this particular release, I am using 5.5.4.847 Trial.

Anyone with the same issue ?

Steve

2

I have 5.5.4.847 (it does not say trial) and mine works. When I push the Green > it takes me to a Execution console page then I enter my parameters and press the Green > in there. I have dbms_output.put_line in my code and I get the output window…

3

Hi Steve,

I’m not sure what’s wrong with that version of Nav that you were using but I don’t think there is anything we can do at this point in time. A better idea is you could download the beta version of Nav 6.0 and see if the problem persists.

Please follow the link below for more info:
http://sqlnavigator.inside.quest.com/ann.jspa?annID=219

You can have both versions of Nav installed side by side so there’s no need to uninstall the other one.

Hope this helps

Cheers

4

I appreciate the response, I just did some testing and found that this is a bug in Nav when using integrated logins and then useing the green > buttton to execute a proc.
Only then do I get the error.

I logged in as normal user not using active directory and the error goes away.

By integrated login I mean that credentials for accessing the database are taken from the windows active directory - so you leave USER name and Password blank and Oracle connects you to the database using activedirectory information.

5

Hi Steve,

Thanks for the information. We will attempt to set up the integrated login with active directory to see if we can reproduce the issue.
I will keep you posted.

Gwen