Return
-
Title
Error in Toad 10.5 when trying to compile code that contains certain characters as Âà -
Description
In Toad 10.5, when trying to compile code that contains certain characters as Âà , a Syntax Error (see below) is shown.
To reproduce the problem please follow the steps below:1] Open Toad 10.5
2] Paste the code below to the SQL Editor and try to compile it
CREATE OR REPLACE PROCEDURE example
AS
p_param VARCHAR2(01) := '''ÂÃ';
BEGIN
NULL;
END;
/Error :'[Error] Syntax check (3: 16): ERROR line 3, col 16, ending_line 3, ending_col 27: The string initializer has a value which is too long and toad will not compile the procedure.' is returnedNote that it is possible to compile this procedure with SQL Plus.In Toad 10.1 you also receive the error when using F5 or control+enter but it is possible to compile it with F9 (ST70359)
Now in toad 10.5 it is not possible to compile it at all. -
Resolution
WORKAROUND:
Compile the package with SQL Plus.STATUS:
Issue fixed in version 11. The latest version of Toad for Oracle can be downloaded at:
-
Defect ID
ST73241