Oracle Forms (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center