SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass date parameter

rosy91Feb 9 2016 — edited Feb 9 2016

HI All,

Just wanted to know if i run the below query its working fine and it will generate files is required path.

BEGIN
schema_name.pkg_extract_history.main_history_all(date'2016-01-24',date'2016-01-30');

END;
the above two parameters are start_date and end_date

But if i pass the same parameter its runs successfully but no files generated.As we have access to the files path also.

For Start_date....select to_char((next_day(trunc(sysdate-14),'saturday')),'YYYY_MM_DD') from dual
For End_date......select to_char((next_day(trunc(sysdate-7),'friday')),'YYYY_MM_DD') from dual

Please suggest some ideas as i m new to Oracle queries.

Thanks,
Lony

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2016

Added on Feb 9 2016

8 comments

523 views