Is SAPDB version (7.3.0.21) a development release, is it pretty stable? I'm currently using 7.3.0 and I haven't really had any major problems with it. I would really like to start using this feature and moving code out of my Python modules into the database.
Thanks for the response and I'm looking forward to the next release of the product. Regards, Scott Benninghoff On Mon, 2002-03-25 at 02:25, Anhaus, Thomas wrote: > Scott Benninghoff wrote > > >I can't seem to nail down the syntax for a stored procedure (DBProc) to > >return a result set to the application. > > >My stored procedure doesn't have any parameters, it just runs SQL > >inside. I have used SP's in other DB's and they have specified that the > >procedure returns a result set. > > >Any help is appreciated. > > The newest SAPDB version (7.3.0.21) provides the possibility to return > a resultset from a stored procedure. Simple Example : > > CREATE DBPROC EXAMPLE RETURNS CURSOR > AS > DECLARE :$CURSOR CURSOR FOR SELECT * FROM SYSDBA:DUAL; > > The new system variable $CURSOR represents the cursor name, which may be > overwritten > in your stored procedure. > > However, since this feature is brand-new, you can only use it from JDBC and > maybe from > Perl and Python. > ODBC and the Precompiler are not able to deal with this feature yet. This > will come with > one of the next versions. > > Thomas > > --- > > Thomas Anhaus > SAPDB, SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
