create table test_blob( blob_column blob ); insert into test_blob(blob_column) values(EMPTY_BLOB());a sample program in the appendix.
Search found 12 matches
- 04.11.2021, 11:30
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Parameters in update doesn't work
- Replies: 5
- Views: 316
Re: Parameters in update doesn't work
Hello,
- 17.10.2021, 08:41
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Parameters in update doesn't work
- Replies: 5
- Views: 316
Re: Parameters in update doesn't work
Did the FPC version change between tests? Yes. Are you sure that the only thing that changed is Lazarus? Yes. Lazarus and version of ZEOS. Are you sure, this isn't a problem on the TBufDataset side? Yes. ---- I checked on the database side - parameters in v$parameters for these SQL are empty. I am ...
- 16.10.2021, 12:21
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Parameters in update doesn't work
- Replies: 5
- Views: 316
Re: Parameters in update doesn't work
To be clear, in all steps the parameter has the content, but after the update is completed and the database is entered from other applications (even SQLDeveloper, etc.), it turns out that the content of the BLOB column is empty.
- 16.10.2021, 12:17
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Parameters in update doesn't work
- Replies: 5
- Views: 316
Parameters in update doesn't work
Hi, I have written a project that moves data from one ORACLE database to another. One of the main functions of this project is to transfer the printouts that are in the database in the BLOB column. For a long time, everything worked flawlessly, but after migrating to the latest version of Lazarus, t...
- 05.07.2021, 14:02
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Re: Connect as SYSDBA or SYSOPER
btw, besides, I didn't have the right version, after installing CodeTyphon with ZESO 7.5.1 it worked, I didn't take into account that only in version 7.3.0 these changes came in, and I had version 7.2
OK, now is good, many thanks
OK, now is good, many thanks
- 05.07.2021, 07:55
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Re: Connect as SYSDBA or SYSOPER
Tried this, but it doesn't work, it's still the ORA-28009 error.
- 04.07.2021, 13:09
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Re: Connect as SYSDBA or SYSOPER
... Or else I am asking for the simplest possible example codes that will connect to the SYS schema on the Oracle database. what should be added in the following? MenuGlowne.ConnectionsTable[MenuGlowne.gConnectionIndex]:= TZConnection.Create(nil); MenuGlowne.ConnectionsTable[MenuGlowne.gConnectionIn...
- 04.07.2021, 13:00
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Re: Connect as SYSDBA or SYSOPER
You don't understand how to switch to SYSDBA or SYSOPER mode during connection, I mean something like TZConnection.Properties.Values ['OCIAuthenticateMode = OCI_SYSDBA']; or TZConnection.AuthenticationMode: = OCI_SYSDBA or how? Where should I put it in the code, because I don't see anything like t...
- 29.08.2020, 13:50
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Re: Connect as SYSDBA or SYSOPER
... I talk about oracle database connection, no Firebird
- 29.08.2020, 09:03
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Re: Connect as SYSDBA or SYSOPER
Sorry, how to connect on SYS schema as SYSDBA role with ZEOS without changing Zeos source?
- 26.07.2020, 08:09
- Forum: ZeosLib 7.2 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 12
- Views: 1190
Connect as SYSDBA or SYSOPER
Hey,
Does anybody know how to connect to oracle db as SYDBA or SYSOPER?
Does anybody know how to connect to oracle db as SYDBA or SYSOPER?
- 20.07.2020, 07:04
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Connect as SYSDBA or SYSOPER
- Replies: 2
- Views: 167
Connect as SYSDBA or SYSOPER
how do i connect to oracle database as sysdba?