General Ledger - EBS (MOSC)

MOSC Banner

date function err

edited Feb 28, 2010 7:29PM in General Ledger - EBS (MOSC) 2 commentsAnswered
Hi,
i am getting this typeof err

 ORA-06502: PL/SQL: numeric or value error: character to number conversion error


i am using like this

creation_date BETWEEN TO_CHAR('''||P_FROM_DATE||''') AND TO_CHAR('''||P_TO_DATE + 1||''')
creation_date <> TO_CHAR ('''||P_TO_DATE + 1||''')

by using the dynamic sql

i dont know weather it is correct or not ?
please provide me the solution.

Thanks&Regads
HB
+91-9176902684

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