Toad World® Forums

Wrong parsing binds ([Error] Explain Plan (12: 23): ORA-01745: invalid host/bind variable name)

Toad 12.11.0.68 x64, Oracle 11.2.0.3 x64, Client Oracle 11.2.0.3 x64, Windows 7 x64.

Seems that parsing on bind is not working as expected.

SELECT ash.inst_id iid,
username,
@sql_id ‘||ash.inst_id || ’ ’ ||ash.sql_id a_sql_id,
sql.child_number,
sql.plan_hash_value,
sql.hash_value,
TO_CHAR (min(sample_time), ‘dd.mm hh24:mi:ss’) first_execute,
TO_CHAR (max(sample_time), ‘dd.mm hh24:mi:ss’) last_execute,
min(SUBSTR (sql.sql_text, 1, 55)) sql_text
FROM gV$active_session_history ash, dba_users u, gv$sql sql
WHERE 1 = 1
AND ash.INST_ID = &&1 here is an error
AND sql.INST_ID = ash.inst_id
AND sql.sql_id = ash.sql_id
AND u.USER_ID = ash.USER_ID
AND u.username like upper(’%&&2%’)
AND ash.sql_id IS NOT NULL
GROUP BY ash.inst_id, username, '@sql_id '||ash.inst_id || ’ ’ ||ash.sql_id, child_number, sql.plan_hash_value, sql.hash_value
ORDER BY min(sample_time);

Somehow cannot insert print screen (your web site is having problems)

Fixed for next beta.