Cognos issue with stored procedure

[dsg1]

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