Sorry for asking again; this time more detailed:
I have defined this dbproc:
CREATE DBPROC LEOLEO
RETURNS CURSOR AS $CURSOR = 'leoleo_cursor';
DECLARE :$CURSOR CURSOR FOR SELECT * FROM DBA.USERS;
The Table DBA.USERS contains some Data.
- When I execute
CALL LEOLEO
in SQL-Studio, I just get "Statement successfully executed. No Result"
if I am defining an ADO Recordset and do the CALL there:
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "CALL LEOLEO",adOpenStatic,adLockReadOnly
I get an Error: "ADODB Recordset: Arguments are of teh wrong type, are out
of acceptable range, or are in conflict with one another"
I am using the 7.4.03.14 Version of SAPDB.
I read in the Mailing List that this was an issue about 1 year ago, but I
thought I'd seen that cursors for dbprocs in ODBC are implemented by now? Is
this a mistake or am I just doing something wrong in my proc or my App?
Thanks!
(Gerald)
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
