Search found 12 matches

by piotr.b.brzeski
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,
create table test_blob(
blob_column blob
);

insert into test_blob(blob_column) values(EMPTY_BLOB());
a sample program in the appendix.
by piotr.b.brzeski
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 ...
by piotr.b.brzeski
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.
by piotr.b.brzeski
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...
by piotr.b.brzeski
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
by piotr.b.brzeski
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.
by piotr.b.brzeski
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...
by piotr.b.brzeski
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...
by piotr.b.brzeski
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
by piotr.b.brzeski
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?
by piotr.b.brzeski
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?
by piotr.b.brzeski
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?