Is it possible to prepare a statement like

  "{call summe2("
  " :a<int,in>, "
  " :b<int,in>, "
  " :ret<int,out> "
  ")}",

which calls a stored procedure defined like so

    "CREATE DBPROC SUMME2 (IN A INTEGER, IN B INTEGER, OUT RET INTEGER) "
    "AS "
    "BEGIN "
    "  SET RET = A + B; "
    "END; "


I'm experiencing problems when doing this from a C++ client:

start SUMME2
a = 1, b = 0, ret = 1
a = 1, b = 1, ret = 9052668
a = 1, b = 2, ret = 9052668
a = 1, b = 3, ret = 9052668
a = 1, b = 4, ret = 9052668
a = 1, b = 5, ret = 9052668
a = 1, b = 6, ret = 9052668
a = 1, b = 7, ret = 9052668
a = 1, b = 8, ret = 9052668
a = 1, b = 9, ret = 9052668
END


The first call succeeds, while any subsequent calls don't. If I rebuild
the statement from scratch before every call, everything works fine.

Is this a problem with the C++ database library I'm using (OTL) or
simply not possible?

Thanks,
Tobias
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to