Hi
I am trying DatePicker values as IN parameter in Procedure. But the datepickers values are empty and not showing in which format they are.
I am passing as my_proc(greenday = :p_datepicker)
and in backend it is my_proc (greenday in varchar2)
but when doing dbms_output the greenday is empty.
How to resolve this? in Apex 5
Please show me how to have DatePicker as
Vinish Kapoor
If you are calling a procedure from a dynamic action, are you submitting the page item p_datepicker in the page items to submit property?
NitinG9
Yes, In Dynamic Action page we provided p_datepicker and other items into submit property.
But nothing has happened, even if we try to have textfield instead of datepicker, the Date values are shown as 'DD-MM-YY' format only. We tried to mask the property as DD-MON-YYYY.
And we are getting error PLS-00224 object 'string' must be of type function or array to be used this way.
Neither with Datepicker nor with Text field we are getting expected result.
Vinish Kapoor
Ok you mean with text field it was working but getting the error due to the format mask.
You can use the date picker only, but pass it by convert to date. Below is the example: