I`m able to insert a row to oracle with the following script
proc sql;
insert into MART.detail_extra(period_key,report_name,audit_time,comments)
values(252,'Commission Detail',&curdate,'REP-Generation of report ');
run;
But when i run using stored process it s giving the following error.
Error:
ERROR: ERROR: ERROR: ORACLE execute error: ORA-01858: a non-numeric character was found where a numeric was expected. With the occurrence of the above ERROR, the error limit of 1 set by
the ERRLIMIT= option has been reached. ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).
Total rows processed: 1
Rows failed : 1
ERROR: ROLLBACK issued due to errors for data set
Has anyone encountered this before ?