Devart Forums

heidenbluth

Hasn't this been fixed in ODAC 12.0.2?
I am just wondering release notes do not mention.

heidenbluth

Thank you,

When enforcing required encryption

OraNet.EncryptionLevel := slRequired;

it works fine with direct TCP/IP.

Unfortunately, an encryption request such as

Code: Select all

OraNet.EncryptionLevel := slRequested;
OraNet.DataIntegrityLevel := slRequested;

doesn't work in conjunction with the following sqlnet server settings:

Code: Select all

SQLNET.ENCRYPTION_SERVER=ACCEPTED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256)
SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256)

I was checking

Code: Select all

SELECT NETWORK_SERVICE_BANNER from from v$session_connect_info

and for my session no network service adapter for encryption is listed.

When using similar SqlNet settings, the adapter is listed:

Code: Select all

SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUESTED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256)

Can you please check this?

heidenbluth

We use
- Oracle 19c local installation (both SQL*Net and database)
- Windows 10 64 Bit
- Delphi 10.4.2
- ODAC11.4.4

Please create the sample table

Code: Select all

CREATE TABLE EMPLOYEES
(
  ID NUMBER,
  DATA XMLTYPE
)

and insert data

Code: Select all

INSERT INTO EMPLOYEES
     VALUES (1, xmltype ('<Employees>
    <Employee emplid="1111" type="admin">
        <firstname>John</firstname>
        <lastname>Watson</lastname>
        <age>30</age>
        <email>[email protected]</email>
    </Employee>
    <Employee emplid="2222" type="admin">
        <firstname>Sherlock</firstname>
        <lastname>Homes</lastname>
        <age>32</age>
        <email>[email protected]</email>
    </Employee>
    <Employee emplid="3333" type="user">
        <firstname>Jim</firstname>
        <lastname>Moriarty</lastname>
        <age>52</age>
        <email>[email protected]</email>
    </Employee>
    <Employee emplid="4444" type="user">
        <firstname>Mycroft</firstname>
        <lastname>Holmes</lastname>
        <age>41</age>
        <email>[email protected]</email>
    </Employee>
</Employees>'));

Run Delphi, and
- Create a new application and change to 64 Bit
- Place a TOraSession component on the form. Use a SQL*Net connection
- Enable Unicode:
Session.Options.UseUnicode := True;
FSession.Options.UnicodeEnvironment := True;
- Place a TSmartQuery on the form, set SQL to "Select * from employees"
- Connect via TOraDatasource to a data grid
- Place a button on the form to open the query

You will get an access violation error in TOraXML.Read line 4477: Check(OCI8.OCIPStreamRead(...));

The exception does only occur with SQL*Net and when Unicode is enabled.

Could you please provide a fix ASAP?

heidenbluth

Thank you

heidenbluth

Haven't heard anything for almost 2 months.
When do you plan to fix it?

heidenbluth

Sample application has been sent again using contact form.

heidenbluth

If you change some options as described below, a TSmartQuery component freezes when inserting two records.

Create a new VCL application and place the following components on the main form and connect them with each other

TOraSession
TConnectDialog
TSmartQuery
TOraDataSource
TDbGrid
TDbNavigator
TButton

Implement the OnClick method of the button as follows

Code: Select all

  OraSession.Options.StatementCache := True;
  OraSession.Options.EnableLargeint := True;
  OraSession.Options.EnableNumbers := True;
  OraSession.Options.UnicodeEnvironment := True;
  OraSession.Options.UseUnicode := True;
  OraSession.Connect;
  SmartQuery.DMLRefresh := True;
  SmartQuery.Options.ReturnParams := True;
  SmartQuery.KeyFields := 'COUNTRY_ID';
  SmartQuery.SQL.Text := 'SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID FROM COUNTRIES';

  SmartQuery.Options.CacheCalcFields := True;
  SmartQuery.Options.CacheLobs := True;
  SmartQuery.Options.DefaultValues := True;
  SmartQuery.Options.DeferredLobRead := True;
  SmartQuery.Options.StatementCache := True;
  SmartQuery.Active := True;

Now, run the application and

Click the button, connect to the HR sample schema
On the navigator, click the "+" button, enter some sample data into the data grid record, and post changes
On the navigator, click again the "+" button, enter some other sample data, and post changes
Now the application freezes.

I sent you a sample project using the contact form earlier this week and attached a sample project, but did not yet get an answer. I am afraid you did not get it.

heidenbluth

The problem occurs both with SQL*Net and direct TCP/IP connections.
The sqlnet.ora file on the server is unchanged as created by Oracle installer.
On the client there was no sqlnet.ora file.

Following a suggestion from this link
https://github.com/oracle/docker-images/pull/1529
our customer created an empty sqlnet.ora file on the client and added a line

Code: Select all

DISABLE_OOB=ON

Now a SQL*Net connetion could be established.
It looks like it would be a good idea to implement the feature "out of band breaks".
The URL mentioned above has some further links to Oracle Doc IDs.

heidenbluth

Hello,
one of our customers complained about ORA-12637 when connection to an Oracle 19.5.1 EE or SE respectively (Solaris).
I haven't Sun Solaris. and Windows has not yet been released, but I guess it may have to do with DISABLE_OOB (Out Of Band Break) Doc ID 373475.1.

Do you support Oracle 19.5.1 ?

Regards,
Holger

heidenbluth

Hello,

As we know, the tnsnames.ora file may have include items such as IFILE=<filename>.
If you comment out such an item like #IFILE=<filename>, the procedure TOraServerEnumerator.GetServerList gets into an infinite loop. This causes the application to hang infinitely while filling the combo box with TNS aliases.

This can easily be avoided by incrementing the loop index before leaving:

if p = 0 then begin
Inc(i); //03.03.2020 added to leave while loop
continue;
end;

Could you please fix this?

heidenbluth

Any news regarding a fix?
It is more than 3 months ago now that I reported the bug including step by step instructions to reproduce.
Could you please provide an update that fixes the problem?

heidenbluth

Sample has been sent.

heidenbluth

Hello,

There is a serious problem with ODAC 11.1.2 that did not exist with ODAC 10.3.9.
You can reproduce it easily by following these steps:
* Use Delphi XE 10.3.3 and Oracle 19c (SQL*Net connection)
* Create a new application
* Add a TOraSession, TLoginDialog, TSmartQuery, TOraDatasource and TDBGrid component and connect components with each other.
* Connect to HR schema
* Set SQL to SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID FROM COUNTRIES

Add a TButton and implement the Button.OnClick event as follows:

Code: Select all

  OraSession1.Connect;
  SmartQuery1.NonBlocking := True;
  SmartQuery1.ObjectView := True;
  SmartQuery1.FetchRows := 2000;
  SmartQuery1.Prepare;
  SmartQuery1.Active := True;

Run the application, and click the button
==> It produces ORA-01002 fetch out of sequence error!

Please help.

heidenbluth

Hello,

What are your plans about Oracle 19.3 database support?
I was asked by one of our clients.

Regards,
Holger

heidenbluth

Thank you.

Devart Forums

Search found 62 matches

Re: Using SQL*Net Native Encryption with Direct TCP/IP

Re: Using SQL*Net Native Encryption with Direct TCP/IP

Bug: Access violation OraXML field / Unicode

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Re: ORA-12637 and Oracle 19.5.1 support

ORA-12637 and Oracle 19.5.1 support

Infinite loop

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Oracle 19.3 support (ODAC VCL)

Re: 10.3.8 and Direct connection fails