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
Search found 6 matches
- 15.07.2024, 08:48
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Multithreading woes
- Replies: 4
- Views: 217
- 10.07.2024, 11:11
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Multithreading woes
- Replies: 4
- Views: 217
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...
- 10.07.2024, 10:31
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: ORA-01722 after upgrade to 8.0.0
- Replies: 3
- Views: 178
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...
- 01.07.2024, 16:22
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: ORA-01722 after upgrade to 8.0.0
- Replies: 3
- Views: 178
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 (...
- 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: 151
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 :-).
Of course, there is a non-zero chance of me discovering a dumb mistake while cutting down my application :-).
- 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: 151
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 &...