Devart Forums

Posted: **Mon 22 Oct 2012 02:02**

Hi

Is it possible to use NonBlocking with a TOraStoredProc component?

If I setup and activate my TOraStoredProc with NonBlocking = True, I get an exception stating "SQL statement doesn't return rows". If I set NonBlocking = False, and activate the Stored Proc, it works fine. This happens both at design time and runtime.

Do I need to handle any event or set any other property to operate this?

Thanks

Posted: **Mon 22 Oct 2012 09:00**

Hello,

Thank you for the information.
We have already fixed the problem.
This fix will be included in the next build.
The next build will be released in one or two weeks.

Posted: **Mon 22 Oct 2012 21:43**

ok. Thanks.

As a paid subscriber to the Professional version with source, is there any chance I can get an update earlier or are you able to provide the fix so I can implement it until such time as it's resolved? Assuming it's not too complicated.

Thanks

Posted: **Tue 23 Oct 2012 09:06**

hello,

To fix this problem, you should replace the following code in the OraClasses.pas module, in the TOCIRecordSet.DoExecFetch; method

Code: Select all

if not FDisableInitFields then begin
      InitFields;
    end;

with

Code: Select all

if not FDisableInitFields then
      InitFields 
    else
      InitFetchCursor;

Posted: **Tue 23 Oct 2012 23:30**

Thanks.
Seems to work perfectly.

Posted: **Wed 24 Oct 2012 08:26**

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

Devart Forums

NonBlocking and TOraStoredProc

NonBlocking and TOraStoredProc

Re: NonBlocking and TOraStoredProc

Re: NonBlocking and TOraStoredProc

Re: NonBlocking and TOraStoredProc

Re: NonBlocking and TOraStoredProc

Re: NonBlocking and TOraStoredProc