Of course it is:

objRS.Open "CALL LEOLEO", objConn,adOpenStatic,adLockReadOnly

and the error message is: "[SAP AG][SQLOD32.DLL][SAP DB]General error;-4000
POS(10) Unknown result table"

Sorry for the mistake.

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:


objRS.Open "CALL LEOLEO", objConn,adOpenStatic,adLockReadOnly

the error message is: "[SAP AG][SQLOD32.DLL][SAP DB]General error;-4000
POS(10) Unknown result table"

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

Reply via email to