반품
-
제목
Error: 'ORA-01745: invalid host/bind variable name' when running script with TO_CHAR -
설명
When the following script is run, the error 'ORA-01745: invalid host/bind variable name' appears:
define p_start_date = TO_DATE('01-Jan-2010','DD-Mon-YYYY');
define p_start_month = TO_CHAR(&&p_start_date, 'MM-YYYY');SELECT &&p_start_month
FROM dual; -
원인
The error is related to the TO_CHAR in the script
-
해결 방안
WORKAROUND:
None.STATUS:
Waiting for fix in a future release of SQL Navigator -
결함 ID
CR12657