Issues after upgrading to 8.0: ORA-01722 and duplicated field names.

[Marian Aldenhövel]

Hi,

I am using ZeosLib in Delphi 10.3 to talk to an Oracle 12 server. This has been working great, thank you for your effort!

For various reasons I have upgraded from 7.2.14 to 8.0.0 and am having two issues.

Issue 1:

When calling Open() on a parameterized TZQuery, I am getting the error ORA-01722 "invalid number". I am expecting an empty result and have run the same query in SQLDeveloper successfully. Downgrading to 7.2.14 the query works fine. The SQL is:

Code: Select all

SELECT
  *
FROM TT_E2E_MM
WHERE
  (
    (apiID=:apiID)
    OR (:apiID IS NULL)
  )
  AND (
    (UPPER(payloadPath) LIKE ('%' || UPPER(:fileName)))
    OR (:fileName IS NULL)
  )
  AND (
    (REQUEST_RERUN=:REQUEST_RERUN)
    OR (:REQUEST_RERUN IS NULL)
  )
ORDER BY transferTimestamp DESC

When opened with :apiID=NULL, :fileName=NULL and :REQUEST_RERUN='Y' it works fine. If I open it with :apiID='4a751a7d-a607-4dda-ba22-8df970467a26', :fileName=NULL and :REQUEST_RERUN=NULL it fails. All three columns are VARCHAR type.

Issue 2:

The same query is connected to a TZUpdateSQL-component. If I double-click that and click on "Get Table Fields" all fields are returned multiple times. See attached screenshot.

Do you have any guidance on what I am doing wrong?

Regards, Marian

[marsupilami]

Hello Marian,

is there any chance for you to provide a small sample app + create script where we can test the problem?

Best regards,

Jan

[Marian Aldenhövel]

I'll try, it might be a while, though :-).

Of course, there is a non-zero chance of me discovering a dumb mistake while cutting down my application :-).