1. Jay Hastings
  2. PowerServer
  3. Tuesday, 9 January 2024 00:50 AM UTC

I have multiple datawaindows that call Oracle stored procedures.  Each one returns only ONE result set.

Within the stored procedure they may use temp tables and/or cursors to loop through the temp tables.  Some are defined cursors (CURSOR c1_TempCursor IS...OPEN c1_TempCursor LOOP) and some may be inline cursors ( For c1_TempCursor in (Select blah blah blah) LOOP).

Either way I get

I cant' find anything on this.  Are there limitations as to the inside of a stored procedure?  I can understand the returned result set.

Any ideas/recommendations?

Thanks in advance

 

Jay

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 9 January 2024 02:38 AM UTC
  2. PowerServer
  3. # 1

Hi Jay;

  Is SQLCA.AutoCommit on or off?

Regards ... Chris 

Comment
There are no comments made yet.
Jay Hastings Accepted Answer Pending Moderation
  1. Tuesday, 9 January 2024 16:48 PM UTC
  2. PowerServer
  3. # 2

Currently not being set at connection

Comment
  1. Jay Hastings
  2. Tuesday, 9 January 2024 17:18 PM UTC
On? Not Off? Our C/S app sets it to off. We just didn't have that in our PS ini. Will try both ways and see. We did just turn on LongConnection but that didn't change anything.
  1. Helpful
  1. Jay Hastings
  2. Tuesday, 9 January 2024 17:57 PM UTC
Setting AutoCommit off appears to have worked. I have LongConnection ON and AutoCommit OFF. Now I need to find the TimeOut settings and extend that.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 9 January 2024 19:01 PM UTC
Hi Jay;

Thanks for the feedback & your good news!

Regards ... Chris
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.