Guang,
r u sure that desired value is being passed in
:maxpromotionid. Try to check the value which could be
null resulting in the invalid number error...
shailesh
- Guang Mei <zlmei_at_hotmail.com> wrote:
> Hi:
>
> I am trying to create some oracle sequence based on
> the current max ID
> value. Does any one know why it does not work in
> sqlplus? I got the
> following error:
>
>
> MAX(PROMOTIONID)
> ----------------
> 69819
> START WITH :maxpromotionid +1
> *
> ERROR at line 3:
> ORA-01722: invalid number
>
>
>
> Here is the script:
> -------------------
> variable maxpromotionid NUMBER;
>
> select max(promotionID)
> into :maxpromotionid
> from hpxpromotion;
>
>
> CREATE SEQUENCE HPXSEQ_Promotion
> INCREMENT BY 1
> START WITH :maxpromotionid +1
> MAXVALUE 999999999
> MINVALUE 1
> NOCYCLE
> NOCACHE;
> ----------------------
>
> If you reply, please send me a copy to
> zlmei_at_hotmail.com
>
> Thanks.
>
> Guang
>
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>
> --
> Author: Guang Mei
> INET: zlmei_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Mon May 22 2000 - 12:43:34 CDT