Hi All,
Normally when ever we want to use date parameter for pl/sql stored procedures we ecounter a common error saying that format string doenst match...
then we do a data conversion to_date(p_date,'RRRR/MM/DD HH24:MI:SS') and then use it..
The better way of doing it is define the data parameter as varchar2 and use the function FND_DATE.date_to_canonical(p_date).This will direclty convert the text string comming from the concurrent programs to date value
ln_processing_date := NVL (fnd_date.canonical_to_date (p_processing_date), SYSDATE);
Monday, June 22, 2009
Subscribe to:
Post Comments (Atom)
3 comments:
Very useful Murthy. Btw, where are you now ?
-Guna.
Post a Comment