re: Unknown Result Table

[Brian Kavanaugh]

> From: "Brian Kavanaugh" <bkavanaugh@stripped>
> To: <sapdb.general@stripped>
> Subject: Unknown Result Table
> Date: Sat, 12 Apr 2003 12:52:41 -0500
>
> Using 7.4.3.17 on Windows 2000. If I create a stored procedure like this:
>
> CREATE DBPROC spUserGetGUID (
> 	IN UserID VARCHAR(50),
> 	OUT USERGUID CHAR(32)
> ) RETURNS CURSOR AS
>
> DECLARE :$CURSOR CURSOR FOR
> SELECT USERGUID FROM Brian.tblUser WHERE UserID = :UserID;
> IF $RC = 0 THEN FETCH INTO :USERGUID;
>
> I get the following error message when I try to call it using ODBC:
>
> 	Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> 	[SAP AG][SQLOD32 DLL][SAP DB]General error;-4000 POS(1054) Unknown result
> table.
>
> If I change it to the following:
>
> CREATE DBPROC spUserGetGUID (
> 	IN UserID VARCHAR(50),
> 	OUT USERGUID CHAR(32)
> ) RETURNS CURSOR AS
>
> $CURSOR = 'MYCURSOR';
>
> DECLARE MYCURSOR CURSOR FOR
> SELECT USERGUID FROM Brian.tblUser WHERE UserID = :UserID;
> IF $RC = 0 THEN FETCH INTO :USERGUID;
>
> When I try to create it in SQL Studio 7.4, I get the same error message,
> pointing to the "fetch" statement.
>
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> General error;-4000 POS(229) Unknown result table.
>
> What should I do to work around this? Before I upgraded from 7.3.0.34, the
> first dbproc was working...

Never mind... I don't need to be declaring/using a cursor here. I used the
wrong template for this db proc...