I am running plsql webtoolkit procedure. I would like to pass a date to do a search within the plsql code
This is what I am passing
http://server:port/apex/proc_name?var1=DTE&var2=09/01/2013&var3=09/30/2013
CREATE OR REPLACE PROCEDURE
proc_name(var1 in varchar2, var2 in date, var3 in date) as
select
col.date_changed from tablea where
(col.date_changed > to_date(var2, 'MM/DD/YYYY') and col.date_changed < to_date(var3, 'MM/DD/YYYY'))
The procedure does compile but I get an error when using the URL .. Is this the proper format for passing date parms in the webtoolkit plsql ?