Print Thread
Access Violation at TOracleDataSet.Open() method
#62731 10/28/21 08:00 AM
Joined: May 2013
Posts: 20
S
Member
OP Offline
Member
S
Joined: May 2013
Posts: 20
Hi,
we have a query like below.
select plsqlapi.function1(param1,param2) from dual;

function1 returns a string.

when we open the query we are getting an access violation.

can you please help us to find it?

Direct Oracle Access 4.1.1.0
Delphi 10.1 Berlin
Oracle 19c

Re: Access Violation at TOracleDataSet.Open() method
Sudheer B #62735 10/29/21 04:42 AM
Joined: May 2013
Posts: 20
S
Member
OP Offline
Member
S
Joined: May 2013
Posts: 20
can you please consider this as high priority?

Re: Access Violation at TOracleDataSet.Open() method
Sudheer B #62737 10/29/21 09:06 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
Can you check if the max_string_size parameter for this database is set to extended? The TOracleDataSet is not compatible with extended string data.


Marco Kalter
Allround Automations
Re: Access Violation at TOracleDataSet.Open() method
Sudheer B #62738 10/29/21 10:01 AM
Joined: May 2013
Posts: 20
S
Member
OP Offline
Member
S
Joined: May 2013
Posts: 20
no, it is set as standard.

Re: Access Violation at TOracleDataSet.Open() method
Sudheer B #62754 11/12/21 02:32 PM
Joined: Feb 2005
Posts: 49
A
Member
Offline
Member
A
Joined: Feb 2005
Posts: 49
We've just ecountered the same behavior...
Delphi 10.2, DOA 4.1.3, Oracle RDBMS 21, Oracle Client 19.
The query is executed correctly (you can see with Oracle Monitor), but something wrong happens internally in delphi when the records are read into the dataset.
It happens quite randomly, only some query...(but still the same, without nothing particular).
We were forced to use Oracle Client 11 / 12 to solve the problem.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.034s Queries: 15 (0.006s) Memory: 2.5111 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 00:34:07 UTC
Valid HTML 5 and Valid CSS