I am constantly getting the following while executing a stored proc which is called from within another stored proc .Server is ORA10g.
ORA-06502: PL/SQL: numeric or value error
I have checked all possbile causes for this error ... .and it not the common casuses .. ..like field lengths , data type mismatch source and destination tables etc . . . .
To track the error i have inserted values in to a temporary table for each statement that is execurted in the procedure.
The statment executions stop at :
EXECUTE IMMEDIATE 'TRUNCATE TABLE Tbl_XXXX';
Is there anything wrong with using execute immediate statements in a procs .....
Or any specific rules that apply to usage of this statement?
I do not know how to correlate a truncate statement with a numeric value error .
Experts please help.