I was suprised to get an error when executing this simple stored
procedure (I reduced the code, the error occurs during the
select-statement):

PROCEDURE "UpdateAccountsOrder" (IN "BenutzerID" INTEGER)
BEGIN
  DECLARE Result INSENSITIVE CURSOR FOR Stmt;
  ...

  PREPARE Stmt FROM
    'SELECT AccountsID, OrderID from accounts where BenutzerID = ?
order by orderID';
  OPEN Result using BenutzerID;
  ...

END

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #700 An error was found in the statement at line 9 and
column 5 (ElevateDB Error #401 The table or view accounts does not exist
in the schema Default)

Any idea what's wrong here?
I am using the latest Build.

Regards Uli

Uli,

<< I was suprised to get an error when executing this simple stored
procedure (I reduced the code, the error occurs during the
select-statement): >>

Can you send me the database catalog that you're using ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Can you send me the database catalog that you're using ?

Done.

Uli

Uli,

Thanks.  The problem is the privileges for the Accounts table.  For some
reason, the privileges for the System user were all cleared, therefore the
procedure couldn't "see" the table.  All stored procedures run, by default,
as the System user.

Use this SQL to correct the issue (run as an Administrator):

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER,DROP
ON TABLE "Accounts"
TO "System"

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Thanks.  The problem is the privileges for the Accounts table.  For some
> reason, the privileges for the System user were all cleared, therefore the
> procedure couldn't "see" the table.  All stored procedures run, by default,
> as the System user.

Great news. Thanks.

Uli