Home » Developer & Programmer » Precompilers, OCI & OCCI » SQLCODE diffs. between Informix and Oracle (Oracle Pro*C - Oracle 10.2.0)
SQLCODE diffs. between Informix and Oracle [message #293015] Thu, 10 January 2008 10:37 Go to next message
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 #293030 is a reply to message #293015] Thu, 10 January 2008 11:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQLCODE is not normalized, if you want ANSI codes you have to compile with MODE=ANSI and use SQLSTATE instead.
SQLCODE is only kept for Oracle code and compatibility with SQL89. Since SQL92 SQLSTATE must be used.

Regards
Michel
Re: SQLCODE diffs. between Informix and Oracle [message #293037 is a reply to message #293015] Thu, 10 January 2008 12:15 Go to previous messageGo to next message
donato
Messages: 53
Registered: November 2007
Location: Barcelona, Spain
Member
Hello!

The problem is that the source code that i'm converting is previous than 1990. It's resulting very difficult, and it uses SQLCODE.

I'll translate it using SQLSTATE.

Thanks, Michel!
Re: SQLCODE diffs. between Informix and Oracle [message #293038 is a reply to message #293037] Thu, 10 January 2008 12:32 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Debian: Pro*C doesn't work well with gcc 4.1 system?
Next Topic: Facing alot of problems, any help is greatly appreciated
Goto Forum:
  


Current Time: Sun Dec 11 08:30:27 CST 2016

Total time taken to generate the page: 0.10898 seconds