Toad World® Forums

Can't compile Public Synoynms using Toad


When executing ALTER PUBLIC SYNONYM HTTPURITYPE compile; as sys in the Toad Editor i get missing or invalid synonym identifier

However when i use sqlplus it works fine

See below Screenshot showing both Examples. Is this an issue with the Client?

please execute next statement on sqlplus and Toad:

col instance for a12;
col AUDSID for a12 ;
col OSUSER_TERMINAL for a60;

SELECT user, (SELECT sys_context(‘USERENV’, ‘INSTANCE’) FROM dual) || ’ ’ || (SELECT sys_context(‘USERENV’, ‘INSTANCE_NAME’) FROM dual) instance, dbms_debug_jdwp.current_session_id sid, dbms_debug_jdwp.current_session_serial serial#, (SELECT sys_context(‘USERENV’, ‘SESSIONID’) FROM dual) AUDSID, (SELECT sys_context(‘USERENV’, ‘OS_USER’) FROM dual)||’(’||(SELECT sys_context(‘USERENV’, ‘TERMINAL’) FROM dual)||’)’ OSUSER_TERMINAL FROM dual;

This is a bug. Toad is not parsing the statement properly. If you select your statement before hitting F9 it’ll work. Eliminate the semicolon from your selection. It should be stripping that, but it’s not. Looks like a second bug. I’ll log the issue.