#1 31 Mar 2008 06:49

vishalaksha
Member
Registered: 31 Oct 2007
Posts: 5

'numeric or value' error

I am working on Oracle Apps 11.5.10.2
I am working on an Alert . In the query of alert I am calling a function In that function I have following code segment
FOR service_values_rt IN cur_service_values
LOOP

v1 := v1|| to_char(to_char(service_values_rt.CUSTOMER_NUMBER)||' '||
to_char(service_values_rt.CUSTOMER_NAME)||
to_char(service_values_rt.SHIP_TO)||
to_char(service_values_rt.BILL_TO)||
to_char(service_values_rt.ORDER_NUMBER)||
to_char(service_values_rt.SERVICE_NAME));

END LOOP;

Due to this 'numeric or value' error is coming.
Please give me some seggestion on it.

Offline

#2 10 Sep 2008 12:45

satish2130
Member
Registered: 10 Sep 2008
Posts: 4

Re: 'numeric or value' error

FIrst check the lenght of V1 variable length.


FOR example

DECLARE
  V_LENGHT VARCHAR2(5);
BEGIN

   V_LENGHT :='SATISH2130';
EXCEPTION

WHEN VALUE_ERROR THEN
      DBMS_OUTPUT.PUT_LINE(' EXCEED LENGHT');
END;

Last edited by satish2130 (10 Sep 2008 12:48)

Offline

Board footer

Powered by FluxBB