I have a problem when I want to execute procedure (id edit mode loaded in the editor) in a package.
There is this code in the package:
**update CD08T006 set value = value + 1
where Parameter = ‘SEQ_FILE_WAPAS’; **
and Toad reports this message, and it is impossible execute the procedure
[Information] Syntax check (2125: 27): Found: ‘value’ The name of the identifier might conflict with a keyword
It is possible to run this code as separate sql query of course and it is possible to run this procedure in package when i call execute from the schema browser: packages/right click on my package/execute package
I remove the all the text “value” from view/toad options/editor/behavior/code templates/rules/condition but it did not help.
I have Toad 10.6.1.3, Oracle 11.2, Oracle client 10g
My coleague has the same problem on the same environment.
In older version of Toad everything was ok.
Thanks for any ideas,