Re: Oracle parameter problem with OraOLEDB driver

From: Michael Jacobs (iq193_at_earthlink.net)
Date: 03/28/04

  • Next message: Mick Board: "Re: Oracle parameter problem with OraOLEDB driver" 
    Date: Sat, 27 Mar 2004 19:05:14 -0500

    Hi Mick,

     As odd as this may sound, try ftBcd as the datatype for the Integer field.

    HTH,

    Michael
    "Mick Board" <mick_board@yahoo.com> wrote in message
    news:40641fbd@newsgroups.borland.com...
    > 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/
    >
    >

  • Next message: Mick Board: "Re: Oracle parameter problem with OraOLEDB driver"

    Relevant Pages

    • Oracle parameter problem with OraOLEDB driver
      ... both Oracle and SQL Server. ... 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 part ...
      (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)
    • Re: Oneys Book, HandleQueryStop(): Why is there no race condition?
      ... The simplest approach is to just deny the query. ... allow the query but leave the system vulnerable as the race condition cannot ... >> If there is need to stop the device, the driver should be ... >>> Conexant Systems, Inc. ...
      (microsoft.public.development.device.drivers)
    • RE: Calculating the cumulative totals for an ending result
      ... Your query fields do not correspond the sample data. ... FROM Odometer INNER JOIN Movement ON Odometer.Unit = Movement.Unit ... "KARL DEWEY" wrote: ... 'Business KM and Personal KM' per unit# with the driver for the month. ...
      (microsoft.public.access.queries)