Issues after upgrading to 8.0: ORA-01722 and duplicated field names.
Posted: 29.06.2024, 14:02
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:
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
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
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