Hi,
I use SQL Developer 1.5.3 with Oracle Database 9i release 1.
When I compile a package, I receive the error ORA-01722: invalid number.
I monitored the requests sent by SQL Developer and it seems that the following request is responsible of the error :
SELECT LINE, POSITION, REPLACE(TEXT, CHR(10), ' '), 'ERROR' FROM SYS.ALL_ERRORS A WHERE A.NAME = :1 AND A.TYPE = :2 AND A.OWNER = :3ORDER BY LINE, POSITION
There are no spaces between ':3' and 'ORDER BY'. Similar bug was reported (by me !) in thread
2328766
Thank you for your help.