Hi guys,

How do you pass a date (with time) paramater to a procedure??

I have a packages with a procedure that takes in two input paramater that are defined as DATE and third paramater as a refcursor. I execute the following:

SQL> var a refcursor
SQL> exec packages_pkg.p_proc('15-JUN-01', '15-JUN-01', :a)


The above works... however, I need to pass the time as well. I tried every combination... nothing seems to work.

Any help would greatly be appreciated.

Thanks.
- Gary