Oracle 9i Update Stored Procedure
Date: 1 Apr 2003 20:04:02 -0800
Message-ID: <96926e78.0304012004.3cee7d5a_at_posting.google.com>
I am trying to run this stored procedure on Oracle 9i. The error I am
getting is at the Update line. Not sure if it is an version error or
what????
CREATE OR REPLACE PROCEDURE SP_UPDATE_DISPLAY_PAGE (
BEGIN
PG_ID IN DISPLAY_PAGE.PAGE_ID%TYPE,
TMPLT_ID IN DISPLAY_PAGE.TEMPLATE_ID%TYPE,
IMG_URL IN DISPLAY_PAGE.IMAGE_URL%TYPE,
PG_TEXT IN DISPLAY_PAGE.PAGE_TEXT%TYPE,
PG_CODE IN DISPLAY_PAGE.PAGE_CODE%TYPE,
_at_OLD_PG_ID IN NUMBER(10),
ERR_NUM OUT NUMBER) IS
UPDATE DISPLAY_PAGE
SET PAGE_ID = PG_ID,
TEMPLATE_ID = TMPLT_ID,
IMAGE_URL = IMG_URL,
PAGE_TEXT = PG_TEXT,
PAGE_CODE = PG_CODE
WHERE PAGE_ID = _at_OLD_PG_ID;
COMMIT;
ERR_NUM := 0;
EXCEPTION
WHEN OTHERS THEN
ERR_NUM := SQLCODE;
END;
/
Received on Wed Apr 02 2003 - 06:04:02 CEST