Board index » delphi » dbExpress X Oracle Stored Proc

dbExpress X Oracle Stored Proc


2004-07-15 09:44:32 PM
delphi225
Hi All.
I'm using Delphi 6, DBExpress and Oracle.
If MY_PROC has a boolean parameter,
SQLStoredProc1 does not list any parameters from MY_PROC,
and does not work, returning "NO DATA FOUND" or "ERROR MAPPING FAILED".
If MY_PROC have not a boolean parameter,
SQLStoredProc1 works fine.
What's wrong?
Ricardo Carmo.
 
 

Re:dbExpress X Oracle Stored Proc

Hi !
You got into 2 problems:
1) OCI (Oracle Call Interface) does not support boolean
parameters. Only PL/SQL supports them.
2) DbExpress driver skips parameters of unknown for him
data type.
You can overcome an issue. Use inplace of boolean-typed
parameters other-typed (integer or char) parameters.
Regards,
Dmitry
--
Dmitry Arefiev, gs-soft Company, community.gs-soft.com
Personal - www.da-soft.com
SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata on your fingertips
MetaBase - ERWIN model in Delphi applications
NCOCI8 - Freeware Delphi to ORACLE direct access
Ricardo Carmo writes:
Quote
Hi All.
I'm using Delphi 6, DBExpress and Oracle.

If MY_PROC has a boolean parameter,
SQLStoredProc1 does not list any parameters from MY_PROC,
and does not work, returning "NO DATA FOUND" or "ERROR MAPPING FAILED".

If MY_PROC have not a boolean parameter,
SQLStoredProc1 works fine.

What's wrong?
Ricardo Carmo.
 

Re:dbExpress X Oracle Stored Proc

Ok Dmitry, thanks.
"Dmitry Arefiev [gs-soft.ru]" <XXXX@XXXXX.COM>escreveu na mensagem
Quote
Hi !

You got into 2 problems:
1) OCI (Oracle Call Interface) does not support boolean
parameters. Only PL/SQL supports them.
2) DbExpress driver skips parameters of unknown for him
data type.

You can overcome an issue. Use inplace of boolean-typed
parameters other-typed (integer or char) parameters.

Regards,
Dmitry

--
Dmitry Arefiev, gs-soft Company, community.gs-soft.com
Personal - www.da-soft.com

SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata on your fingertips
MetaBase - ERWIN model in Delphi applications
NCOCI8 - Freeware Delphi to ORACLE direct access

Ricardo Carmo writes:
>Hi All.
>I'm using Delphi 6, DBExpress and Oracle.
>
>If MY_PROC has a boolean parameter,
>SQLStoredProc1 does not list any parameters from MY_PROC,
>and does not work, returning "NO DATA FOUND" or "ERROR MAPPING FAILED".
>
>If MY_PROC have not a boolean parameter,
>SQLStoredProc1 works fine.
>
>What's wrong?
>Ricardo Carmo.