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
Problem While Booking Order
-
ahmadbilal
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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>
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>
Who is online
Users browsing this forum: No registered users and 5 guests