Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01722: invalid number desde jdeveloper

921249Mar 1 2012 — edited Mar 4 2012
Hi!

Because when I call a procedure that executes the following statement:

update in September TABLE_TRANSFORM_COORDINATES GEOMETRY = SDO_CS.TRANSFORM (SDO_CS.TRANSFORM (MDSYS.SDO_GEOMETRY (2001, 3785, MDSYS.SDO_POINT_TYPE (NVL (REPLACE (-6843865.7686422905, '.', ','), 0), NVL (REPLACE (-4451692.522474714 , '.', ','), 0), NULL), NULL, NULL), 4055), 8307);

I get the following error:

java.sql.SQLSyntaxErrorException ORA-01722: invalid number

But if I run it from the SQLDeveloper this does not happen??

help please!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2012
Added on Mar 1 2012
#application-development-in-java, #jdeveloper-and-adf
4 comments
1,055 views