creating stored procedures w/ isql 4.11
I am getting a syntax error when trying to create a stored procedure in
ESQL 4.11. It works in DBACCESS 5.01. I am using Online 5.01.
Here is the script:
CREATE PROCEDURE VLD_SITE(aSiteId INTEGER, ErrMsg VARCHAR(70))
DEFINE SqlError, IsamError, Key, SiteId INTEGER;
DEFINE ErrText CHAR(70);
ON EXCEPTION IN (-690, -691, -692)
SET SqlError, IsamError, ErrText
TRACE "Caught Exception";
RAISE EXCEPTION SqlError, IsamError, ErrText;
END EXCEPTION;
LET Key = aSiteId;
SELECT s.ObjectId
INTO SiteId
FROM Sites s
WHERE s.ObjectId = Key;
IF SiteId IS NULL THEN
TRACE "Throw Exception";
RAISE EXCEPTION -691, 0, ErrMsg;
END IF
END PROCEDURE;
Has anybody gotten this error? Is this a bug or does ISQL 4.11 not support
stored procedures?
Thanks in advance.
--
Rick Hamel
Database Administrator
Marcam Corporation
<rickh@marcam.com>