error mesage at insert apears only in oracle
Hello,
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!
Subject
Views
Written By
Posted
error mesage at insert apears only in oracle
3435
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.