| SQLCODE diffs. between Informix and Oracle [message #293015] |
Thu, 10 January 2008 10:37  |
donato
Messages: 53
Registered: November 2007
Location: Barcelona, Spain
|
Member |
|
|
Hello!
I'm using Oracle Pro*C - Oracle 10.2.0, in a HP-UX B.11.11.
I'm migrating a Informix D.B. to Oracle 10.2.0.
Actually, i got a little problem: the SQLCODE codes are different between the 2 D.B. technologies.
For example, the SQLCODE = -378 in Informix means:
Record currently locked by another user
And, in Oracle, the code ORA-00378 means:
ORA-00378 buffer pools cannot be created as specified
I was looking in the 'OracleŽ Migration Workbench - Reference Guide for Informix Dynamic Server Migrations' and other docs, but i don't found nothing.
Anybody knows where i can see any kind of comparision?
Thanks!
|
|
|
|
|
|
|
|
| Re: SQLCODE diffs. between Informix and Oracle [message #293038 is a reply to message #293037] |
Thu, 10 January 2008 12:32  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If your program is now only for Oracle you can still use SQLCODE, it is easier as error codes are the same than in Oracle Error Messages documentation but you have to be aware that you can't compare them with other DB SQLCODE.
More each DB has its own SQLCODE set that may not have any correspondence in others.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
