Delphi 5 TStoredProc and Oracle 9i

HaganRJ

unread,

Nov 3, 2003, 10:54:34 AM11/3/03

to

Using Delphi 5, BDE 5.01, and Oracle 9i. When using a TStoredProc object I don’t see Boolean parameters in the parameters properties of the stored procedure. It list varchar2 parameters up to the first Boolean. Since I am not using the Boolean parameters and since they are the last 3 output parameters in the procedure, I ran it anyway. I get the error ‘wrong number or types of arguments in call’. I also have tried adding the missing parameters, but that doesn’t work either. When I run it with the parameters that I have added, I get the error ‘Operation not applicable’. I thought it might be the number of parameters, there are 13 (9 in and 4 out), but I tried using the TStoredProc on another procedure with only 7 (4 in and 3 out). The first output parameter is Boolean and only the first 4 varchar2 input parameters are displayed in the object.

Thanks for the help.

Eric Hill

unread,

Nov 3, 2003, 12:04:37 PM11/3/03

to

I have almost zero experience with the BDE, but Oracle doesn't natively
support boolean fields. They are typically stored as a sincel character
(Y/N, T/F, etc) or number (0/1) in the database. The application must make
the translation itself.

Eric

Dion Brown

unread,

Nov 12, 2003, 5:16:36 PM11/12/03

to

How are you connecting with the BDE? SQLLinks for ODBC?

If SQLLinks I'm not sure Oracle 9i is supported (Someone else might be able
to confirm this). If ODBC can you let me know which version and I'll give it
a try with D7 and the BDE (don't have D5 or D6 installed any more).

Also which version of 9i (9.0.1 or 9.0.2), SQLPLUS should tell you when you
log in.

I you are using Oracle a lot I would strongly recommend that you drop the
BDE and use Direct Oracle Access (DOA)
http://www.allroundautomations.com/doa.html

Regards

Dion.

"HaganRJ" <ronald...@keesler.af.mil> wrote in message
news:3fa6884a$1...@newsgroups.borland.com...

Dion Brown

unread,

Nov 12, 2003, 5:09:15 PM11/12/03

to

Actually PL/SQL does support Boolean, see
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm#10887
(you might need to sign up for a free account to see this).

Oracle's SQL doesn't have Boolean data type, but then nether does MS SQL (it
has bit, but not Boolean).

Dion

"Eric Hill" <er...@ijack.net> wrote in message
news:3fa68ab3$1...@newsgroups.borland.com...

Dion Brown

unread,

Nov 13, 2003, 4:02:57 PM11/13/03

to

I tried this a few ways.

The BDE using SQLLinks does not see the Boolean parameter.
The BDE using ODBC does see the Boolean parameter, but thinks it is a float.
Pass in a number raises an error from Oracle saying the data types are
incorrect.
ADO (Using the Oracle provider) sees the parameters as an interface, I
wasn't able to figure out what to pass.
DOA (Direct oracle access) doesn't have a Boolean parameter. I haven't had a
good look, but in my quick try couldn't call it.

Looks like you are stuck changing the parameter to a char or a number.

Regards

Dion.

"HaganRJ" <ronald...@keesler.af.mil> wrote in message
news:3fa6884a$1...@newsgroups.borland.com...