ORA:06502 Error on Date Conversion Oracle Forms and Reports
Hello Everyone,
I am receiving the ORA:06502 error on my form and am having some trouble debugging it. The form is calling a procedure with two parameters. An ID and a date. I am attempting to concatenate the ID and Date values and then send them to a report. Currently the code looks like this:
v_id varchar2(35);
v_id := :control.id||':'||(TO_CHAR(:control.date, 'yyyymmdd')||'0100')
I am sending the variable 'v_id' to the report. The procedure functionality is working properly, because when I run the form without the report, my crud operations are working. The error gets thrown when I attempt to send the parameters to the report. :Control_id is a Char 35, and control.date is a date. The report parameter p_id is a Char 35 as well. Does anyone have any suggestions?