Oracle parameter problem with OraOLEDB driver

From: Mick Board (mick_board_at_yahoo.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 23:27:49 +1100

Hi,
I'm in the process of converting a Delphi application from BDE to ADO for
both Oracle and SQL Server. At this stage I'm only working on the
conversion for Oracle. I've run into a problem with using the OraOLEDB
driver and parameter queries. I am using this driver rather than the
Microsoft driver because of it's support for CLOBs.

I have a query which contains parameters, one of which is an integer. My
query has its datasource value set to a datasource as it is the detail part
of a master detail relationship. The integer parameter that I'm having
problems with should be joined to a field of the same name (part of the
select statement) in the master query (returning only records which match).
However, I'm receiving an obscure Oracle error message: "Project xyz raised
exception class EOleException with message 'Unspecified error'. Process
stopped. Use Step or Run to continue".

What I'm trying to do works fine in BDE. It also works fine (from what I
can tell) with Microsoft's version of the drivers. From what I can tell
this technique also seems to work ok with text data using this driver.

The underlying data is a Number(38) field. I am trying to use an ftInteger
datatype, but have also tried the ftfloat and ftLargeint.

I've tried some tests with a simple parameter query (without a datasource
but integer parameters) and this also seems to cause problems, yet from help
from the newsgroups I could get around this one problem by specifying the
parameter's type in code prior to opening the query. However, this trick
doesn't seem to work where my query has a datasource.

I am really struggling with this and would appreciate any help (someone
somewhere must have experienced this before ... I hope).

Thanks in advance,

Mick. 

--
------------------------------------------------------
InterNet Australis
http://www.australis.com.au/

Relevant Pages

  • Re: Oracle parameter problem with OraOLEDB driver
    ... "Mick Board" wrote in message ... I am using this driver rather than the ... > I have a query which contains parameters, one of which is an integer. ... > query has its datasource value set to a datasource as it is the detail ...
    (borland.public.delphi.database.ado)
  • Re: Oracle parameter problem with OraOLEDB driver
    ... I am using this driver rather than the ... > I have a query which contains parameters, one of which is an integer. ... > query has its datasource value set to a datasource as it is the detail ... > What I'm trying to do works fine in BDE. ...
    (borland.public.delphi.database.ado)
  • Re: Oracle parameter problem with OraOLEDB driver
    ... > Hi Mick, ... I am using this driver rather than the ... >> I have a query which contains parameters, one of which is an integer. ... >> query has its datasource value set to a datasource as it is the detail ...
    (borland.public.delphi.database.ado)
  • DTS error with Oracle 9.x
    ... I'm trying to get a DTS package to import data from Oracle into ... I can construct my query with no ... I've been using Oracle's 9.02.00.05 driver. ... Oracle driver 2.575.1117. ...
    (microsoft.public.sqlserver.dts)
  • Re: C# oracle connectivity
    ... roy fine ... how can i connect to oracle using the following ... > MS driver has a bug limiting the length of the DataSource, ...
    (microsoft.public.dotnet.framework.adonet)