-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|