• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Powerserver 2022 using Stored Procedures - Fetch Errors

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Powerserver 2022 using Stored Procedures - Fetch Errors

  1. How-to
0
Votes
Undo
  1. Jay Hastings
    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

 

  1. Oracle
  2. PowerServer
  3. Stored Procedure
Powerserver
Why do I get a -1 on retrieval using datastore/dat...
Responses (2)
Chris Pollach @Appeon
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
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
Load more comments
Jay Hastings
  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
Jay Hastings
  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
Chris Pollach @Appeon
  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.