date function err
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
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
0