I am getting this error when I try to login…THis is the VERY FIRST time login
into SQL Navigator
ORA 00604: error occured at recursive SQL Level 1
ORA 06502: PL SQL : numeric or value error : Character String buffer too small
ORA 06512: at line 16
appreciate ur help
If you login through sqlplus (or sqlplusw), do you get the same error?
Which version of SQLNav are you using? Could you download the latest 6.3 beta and try it out as well? You can get 6.3 beta from http://sqlnavigator.inside.quest.com/shares/sqlnavigator/sbin/beta/1828/sqlnav_220.127.116.118-KX_beta.zip
I am getting SAME error in sqlplus
Then I’d think something is wrong with the user you’re logging in with. Perhaps some code - with a bug causing the error you see - is executed upon login?
I’d inform your DBA from the problem you have.
I am trying to login as APPS user…I tried changing host name into ip address in tnsnames.ora file.
I tried to login to sqlplus
But nothing worked out…
DBA says that there is nothing fired at login and also there is no tablespace issue
Hey Pras – The next thing I would try is try to login using sqlplus as the same user from a different machine where a different user has been successful logging in. If that works, it is most likely something in your client configuration on your machine. If it throws the same error, then it is most likely something with that user or some logon trigger or other code that is fired off is blowing up for that user and it would have to go back to the DBA.
Also, since it’s not a SQL Nav problem, you may want to try posting it on the database Oracle forums to see if someone there can help: http://forums.oracle.com/forums/category.jspa?categoryID=18.
There is a free tool come with SQL Navigator called “Quest SQL Tracker” You can use this tool to monitor SQL Navigator during login and it may give you an idea what’s going on.
Start Menu -> All Programs -> Quest Software -> SQL Navigator x -> Quest SQL Tracker
Hope this help.