Page 1 of 1

Problem While Booking Order

Posted: Wed Jan 23, 2008 2:05 am
by sunnyk
Hi All,

While Booking Order I am getting following Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package ASO_ORDER_FEEDBACK_UPDATE_PVT Procedure UPDATE_NOTICE" Kindly provide assistance in this regard.

With regards
Sunnyk

Posted: Wed Jan 23, 2008 8:39 am
by ahmadbilal
Make sure that the file asoqueue.sql is present in $ASO_TOP/patch/115/sql directory
Make sure that user ?ASO? and ?APPS? have execute rights on SYS.DBMS_AQADM and SYS.DBMS_AQ packages with Grant option
Run $ASO_TOP/patch/115/sql/asoqueue.sql in the following manner:
sqlplus APPS/<APPS password> @asoqueue APPS <APPS password> ASO <ASO password> SYSTEM <SYSTEM password>

Posted: Mon Jan 28, 2008 9:20 am
by sunnyk
Dear Ahmed

Thankyou for the Prompt Reply

With regards
Sunnyk