InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumFri, 24 Apr 2026 19:09:39 GMT20http://forum.strataframe.net/FindPost11013.aspxHi there,</P><P>I am using Oracle SPs to handle my Inserts, Updates, etc.&nbsp; I noticed that I had to have an out parameter named ROWCOUNT in order for my SPs to work.</P><P>Does SF use the ROWCOUNT parameter?&nbsp; Is there a way I can access via my BOs?</P><P>Cheers,</P><P>KeithWed, 22 Aug 2007 16:58:36 GMTKeith Harveyhttp://forum.strataframe.net/FindPost11014.aspxThe ROWCOUNT is needed to determine how many rows were modified by the last action.&nbsp; So, it's either going to contain 1 or 0 so that the BO can check for concurrency issues.&nbsp; 1 means the record was successfully updated, 0 means the record was not updated because it's been deleted, or the concurrency checks failed.&nbsp; We had to include a ROWCOUNT because silly Oracle does not automatically return the RecordsAffected through the ExecuteNonQuery() on the OracleCommand objects for stored procedures.&nbsp; So, in order to determine whether the record was updated, we had to include the ROWCOUNT parameter that should return the number of records affected by the command.</P><P>Looking at my Oracle unit tests, we use this to stuff the row count into the parameter:</P><P>"P_ROWCOUNT" := SQL%ROWCOUNT;</P><P>As for only returning a set number of rows... you can certainly use the WHERE ROWCOUNT &lt; X as the equivalent of SQL TOP X.&nbsp; We do this in places where we need to generate a SELECT TOP dynamically.&nbsp; But if you want the raw rowcount of the table, you'll just have to use SELECT COUNT(*).Wed, 22 Aug 2007 16:58:36 GMTStrataFrame Team