> ...I'm using Oracle 8i
Unfortunately I don't have any experience with Oracle. I have heard stories
about problems with the BDE/Oracle combination but haven't really paid any
attention to them. Maybe one of the newgroup archives might turn something
up?
>> If the BDE, does the stored proc work when you execute is
>> through the SQL Explorer?
> Just tried it and it works through Explorer! Still doesn't work through
> the app though.
So it looks like it is either some setting in Delphi or a problem retrieving
the value of the output parameter. I don't really know where to go from
here, but maybe some things you could try are:
- when you add the parameters manually, make sure that you set all of the
required parameters such as ParamType and DataType
- don't reference the output parameter to see if it is really that which is
causing the error or possibly something else.
HTH,
John
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/