Search found 6 matches

by Marian Aldenhövel
15.07.2024, 08:48
Forum: ZeosLib 7.3/8.0 Forum
Topic: Multithreading woes
Replies: 4
Views: 64

Re: Multithreading woes

Yes, that did the trick.

To be precise I set the connection property at design time using the visual editor, but the result obviously is the same.

I would like to apologize for my weak googling, especially as I had a hunch it might be something like this.

Thank you very much!

Regards, Marian
by Marian Aldenhövel
10.07.2024, 11:11
Forum: ZeosLib 7.3/8.0 Forum
Topic: Multithreading woes
Replies: 4
Views: 64

Multithreading woes

Hi, I am using Zeos 8.0 from Delphi 10.3 in an ETL-Type application where I fetch data from a REST-API and pump it into an Oracle DB. I have set things up so that various REST endpoints can be serviced from separate threads. Unfortunately this fails by throwing an EExternalException. The oracle clie...
by Marian Aldenhövel
10.07.2024, 10:31
Forum: ZeosLib 7.3/8.0 Forum
Topic: ORA-01722 after upgrade to 8.0.0
Replies: 3
Views: 74

Re: ORA-01722 after upgrade to 8.0.0

Hi, Thank you for your analysis. Indeed, by specifying REQUEST_RERUN to be of string-type the error goes away. I simply assigned a default value using AsString to achieve that. REQUEST_RERUN is declared as VARCHAR with a check-constraint limiting it to 'Y' and 'N' to emulate a boolean value. I am ha...
by Marian Aldenhövel
01.07.2024, 16:22
Forum: ZeosLib 7.3/8.0 Forum
Topic: ORA-01722 after upgrade to 8.0.0
Replies: 3
Views: 74

ORA-01722 after upgrade to 8.0.0

Hi, I am using ZeosLib in Delphi 10.3 to work with an Oracle database. Thank you for your great work! For various reasons I have upgraded from ZeosLib 7.2.14 to 8.0.0 and now my project triggers ORA-01722 Invalid Number on a seemingly innocent query: SELECT * FROM TT_ZEOS WHERE ( (apiID=:apiID) OR (...
by Marian Aldenhövel
01.07.2024, 12:28
Forum: ZeosLib 7.3/8.0 Forum
Topic: Issues after upgrading to 8.0: ORA-01722 and duplicated field names.
Replies: 2
Views: 55

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

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 :-).
by Marian Aldenhövel
29.06.2024, 14:02
Forum: ZeosLib 7.3/8.0 Forum
Topic: Issues after upgrading to 8.0: ORA-01722 and duplicated field names.
Replies: 2
Views: 55

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

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 &...