Hi
We have a Cognos 10 report studio report, which is using a stored procedure in the backend (Oracle db) which takes some parameters (all varchar input parameters). Based on these parameters (READ/UPDATE as values), it runs a "Select" statement or "Delete,Update and Select" statement and returs some data.
The report runs fine in development, but throws an error in QA or Prod : " UDA-SQL-0107 A general exception has occurred during the operation "execute". ORA-01036: illegal variable name/number RSV-SRV-0042 ".
The user ids have been given all the priviledges for Dev, QA and Prod database.
Need some help resolving this issue.
Thanks
DSG