Page 1 of 2
TOraSession.Options.Net and TOraQuery.Options.AutoClose
Posted: Tue 07 Nov 2006 14:35
by Legion
If Net option is TRUE, AutoClose working properly or not?
Posted: Wed 08 Nov 2006 13:21
by Plash
The AutoClose option of TOraQuery works properly with Net option.
Posted: Wed 08 Nov 2006 18:10
by Legion
AutoClose - TOraDataSet will close OCI cursor after fetching all rows. Allows to reduce the number of opened cursors on the server.
In designer
Code: Select all
AutoClose is True, FetchAll is True,
OraSquery.SQL (TabCursor parameter type is Cursor)
begin
Pkg.Prc(:TabCursor);
end;
In runtime
Code: Select all
OraQuery.Open; OraQuery.Close; OraQuery.Open;
This code, if NET is False, not increase number of opened cursors on server, otherwise, cursor number increased
Code: Select all
select count(*) from sys.v_$open_cursor;
Posted: Thu 09 Nov 2006 10:32
by Plash
We cannot reproduce the problem.
Posted: Mon 13 Nov 2006 13:40
by Legion
I send my test to support mail.
Posted: Wed 15 Nov 2006 10:47
by Legion
What's about my test project?
Posted: Thu 16 Nov 2006 13:01
by Plash
We have not received your e-mail. Please send your test project to
[email protected] again.
Posted: Mon 20 Nov 2006 17:01
by Legion
I send my test to
[email protected]
Posted: Fri 24 Nov 2006 10:29
by Legion
I wait answer...
If you not recieved my mail again, I upload my test here:
http://rapidshare.com/files/4615278/Test.zip.html
Posted: Fri 24 Nov 2006 15:13
by Plash
We have not received your e-mail and we cannot download your test project from the link that you have specified.
Posted: Fri 24 Nov 2006 16:54
by Legion
Posted: Mon 27 Nov 2006 13:49
by Plash
We have tested your project. The AutoClose option doesn't work correctly because you set AutoPrepare and KeepPrepared options for the query component. These options conflict with AutoClose when using REF CURSOR.
Posted: Mon 27 Nov 2006 16:02
by Legion
plash wrote:The AutoClose option doesn't work correctly because you set AutoPrepare and KeepPrepared options for the query component. These options conflict with AutoClose when using REF CURSOR.
What should be a correct combination of options in this case?
Posted: Tue 28 Nov 2006 10:02
by Plash
Set the AutoClose option to True, AutoPrepare and KeepPrepared options to False.
Posted: Tue 28 Nov 2006 10:51
by Plash
We have fixed the problem with preparing. The fix will be included in the next build of ODAC.
But we don't recommend preparing ODAC datasets with a PL/SQL statement returning REF CURSOR. When you prepare such dataset, the query is executed to get the list of fields. When you open, the dataset it is executed the second time. So if you prepare the dataset with a PL/SQL statement returning REF CURSOR it is executed twice.