I can’t reproduce the ORA-1005, but it won’t work with the ANSI join on more than one table anyway. There was a bug in 12.5 and 12.6 where ANSI join on more than one table fails. A single JOIN is OK. This has been fixed for 12.7 which is currently in beta.
I created my proxy user…
create user scott_proxy identified by scott_proxy;
grant create session to scott_proxy;
alter user scott grant connect through scott_proxy;
…and connected to Toad using SCOTT_PROXY[SCOTT]/scott_proxy. At this point I can see queries being executed fine by viewing the spooled SQL output, but the bug in 12.5/6 is preventing anything useful from coming of it. I tried with the save passwords option
both on and off.
On 03/19/2015 09:44 AM, stefan.polzer wrote:
Pick list aborts with ORA-01005 when connected via PROXY log-in
Thread created by stefan.polzer
I hope you can help me out here!
Since 12.5. pick list does not work any more when connected via PROXY, it even throws ORA-01005 when I want to trigger it or when the intervall is over.
It works fine only if I am NOT connected with a proxy.
Thanks for any help!
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.