ORA-00000, Delphi 6, Oracle 9i

[Jim Rollins]

Hi all,

I've been running DOA4.04 on D6 against 8i and 9i DB's running on other servers. I was using an 8i client. I installed 9i on my PC this weekend and now my D6 programs are raising "ORA-00000: Normal, successful completion" errors when I run TOracleQuery.Select. Has anyone seen this or know how to make it stop?

Thanks for the help.

Jim

 

[Jim Rollins]

Whoops. Typo. It should read "TOracleQuery.Execute". Sorry about that. The SQL itself is "SELECT COUNT(*) num FROM CU".

 

[Marco Kalter]

In general there should not be any problem accessing an 8i database with a 9i client. I'm thinking that something is wrong with this 9i client though. Did you upgrade an existing 8i client to 9i, or was this a fresh installation?

 

[Mikolla]

I've been running DOA4.0.5 on D7 against 8i and 9i DB's running on other servers. I was using an 8i client. I delete 8i and reinstalled 9i on my PC and now my D7 programs are raising "ORA-00000: Normal, successful completion" errors when I run

OracleQuery1.Clear;
Oraclequery1.SQL.Add('select Label from Phone where classified = 1003');
Oraclequery1.Execute;

Help me !!

 

[Marco Kalter]

I think you should uninstall your Oracle Client again, delete any remaning Oracle directories, and reinstall the 9i client again.

 

[laps]

Problem was decided with the tuning

OracleSession1.Preferences.UseOCI7:=True;

 

[laps]

Marco Kalter
So that you learn mazdai

 

[Marco Kalter]

Setting UseOCI7 to True doesn't seem like a good solution. This way you cannot use any OCI8 specific functions, such as LOB's, Objects, and more.

A clean reinstall might still be a good idea...

 

[laps]

A clean reinstall might still be a good idea...

Yes, idea good but this does not help. Even if it was originally established only Oracle 9i Client