D2007 stored procedures and Oracle

[Maj Johansson]

I've bumped into a problem when trying to execute a stored procedure in an
Oracle 10
database, using dbexpress (dbxora30.dll). It works fine with core lab driver
(dbexpoda40.dll).

I'm using TSQLStoredProc and need to set an integer parameter at runtime.
I've tried to set the
type to ftFMTBcd instead of ftInteger, and to set the precision to 10, but
it doesn't help.

The stored procedure is created with CREATE OR REPLACE PROCEDURE
DELETE_SESSION(ASESSIONID IN NUMBER) AS...

The interger value is Oracle is NUMBER(10,0).

Any suggestions?

Maj

[Thomas Miller]

Yes, use the Core Lab driver. It is much more reliable then the ones
Code Gear includes. Also Core Labs or All Around Automation will fix
the bugs in a driver much faster then Code Gear. The also don't remove
the code for supported database from the current version. You will find
that they support 8 - current, sometimes even version 7.

Code Gear seems to think that you will only use the a specific version
of any database per version of Delphi.

Go commercial, you will never regret it. Also stop buying the
Enterprise version. You are much better off taking the savings and
spending it on commercial 3rd party VCL components that work.

Post by Maj Johansson
I've bumped into a problem when trying to execute a stored procedure in an
Oracle 10
database, using dbexpress (dbxora30.dll). It works fine with core lab driver
(dbexpoda40.dll).
I'm using TSQLStoredProc and need to set an integer parameter at runtime.
I've tried to set the
type to ftFMTBcd instead of ftInteger, and to set the precision to 10, but
it doesn't help.
The stored procedure is created with CREATE OR REPLACE PROCEDURE
DELETE_SESSION(ASESSIONID IN NUMBER) AS...
The interger value is Oracle is NUMBER(10,0).
Any suggestions?
Maj

--
Thomas Miller
Chrome Portal Project Manager
CPCUG Programmers SIG Chairperson (formally Delphi)
Delphi Client/Server Certified Developer

http://programmers.cpcug.org/
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus