MySQL Forums
Forum List  »  Oracle

error mesage at insert apears only in oracle
Posted by: Andrei Tomas
Date: March 28, 2011 07:29AM


I`m trying to make an insert in mysql database.
In a oracle databse when I try to insert values like ip`s in bigint column I get this error :505: SQL Query error, [nativecode=ORA-01722: invalid number] in query.

Instead, in mysql I don`t get any error , the insert query runs but he transform the values from the ip`s tables in int type without generating any error code.

I whant in this case that mysql to generate an error message.

Have any idea>

Thank you!

Options: ReplyQuote

Written By
error mesage at insert apears only in oracle
March 28, 2011 07:29AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.