UPDATE PROBLEM - ORA-06502

I have datasource with numeric, date and text columns. I fill this columns with their type and i am getting.

"ORA-06502: PL/SQL: numeric or value error: character to number conversion error"

when i commit.

I am sure that i put every field with its type.

ora-06502

asked 07 Jul '12, 02:07

Pol
11●1●5
accept rate: 0%

3 Answers:

0	I have more data. I modify a text in a row, i push botton to commit and i get ORA-06502. Then, i focus next row and push botton to commit and i get update ok. i do not why, if you want more data, please ask me. thanks. link answered 07 Jul '12, 07:23 Pol 11●1●5 accept rate: 0%

0	Hi Pol, is it a grid component. Could you please send the component xml and the value you set? link answered 07 Jul '12, 07:29 Ugur Kocak ♦ 561●6 accept rate: 23%

0	Hi Pol, It was a bug in the formspider online database and we have fixed it. The bug is not found in version 1.0. Thank you very much for the feedback. Regards link answered 07 Jul '12, 13:16 Ugur Kocak ♦ 561●6 accept rate: 23%

Your answer

toggle preview

community wiki

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Tags:

Asked: 07 Jul '12, 02:07

Seen: 1,556 times

Last updated: 07 Jul '12, 13:16