Re: Oracle 9i Update Stored Procedure

leah_deann_at_hotmail.com (Leah) wrote in message news:<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 (
>
> 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
>
> BEGIN
>
> 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;
> /
In future, it would be a good idea to tell us the error message rather than have us guess! But in this case I can see at least one problem: Oracle identifiers cannot begin with '_at_' they MUST start with a letter. Received on Wed Apr 02 2003 - 12:00:46 CEST