Hi,
I am trying to create a stored procedure based query subject in FM. Both the input parameter data types are character16
but the it is a date field. when i try to add parameters (startdate and enddate), it is giving me error. I have changed the
format to date still it is throwing an error. Any thoughts ....
The two values i have given are :
to_date(#sq(prompt('START_DTM','date'))#
to_date(#sq(prompt('END_DTM','date'))#
The error message i am getting is this one:
RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'.
UDA-SQL-0107 A general exception has occurred during the operation "fetch".
ORA-01002: fetch out of sequence
UDA-CUR-0000 Unable to fetch the row.
Thanks in advance.
-Subbu.
your procedure accepts characters as parameters and you are passing date, try removing that to_date function
and second thing, your are missing the closing ) for the to_date function, but like i said, remove it and replace it with to_char