If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Stored procedure based query subject with input parameters

Started by subbu_uppuluri, 07 Nov 2012 11:40:29 AM

Previous topic - Next topic

subbu_uppuluri

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.

 

adik

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