February 19, 2008 at 9:58 am
I am calling Oracle Stored Procedure in SSRS report.
SP returning ref cursor.
With Out Parameters SSRS report is working fine.
If I am trying to pass the Parameter values to SP through SSRS report
I am getting the below error.
Can some one can send an example link like how to pass values to SP through SSRS ?
thanks for great help.
Srini
===================================
An error occurred while retrieving the parameters in the query.
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 114
ORA-06512: at line 1
(Microsoft Report Designer)
===================================
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 114
ORA-06512: at line 1
(System.Data.OracleClient)
------------------------------
Program Location:
at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at System.Data.OracleClient.OracleCommandBuilder.ResolveName(OracleCommand command, String nameToResolve, String& schema, String& part1, String& part2, String& dblink)
at System.Data.OracleClient.OracleCommandBuilder.DeriveParametersFromStoredProcedure(OracleConnection connection, OracleCommand command)
at System.Data.OracleClient.OracleCommandBuilder.DeriveParameters(OracleCommand command)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.GetStoredProcedureParameters(ArrayList& oracleParameters)
at Microsoft.ReportingServices.DataExtensions.CommandWrapper.GetStoredProcedureParameters()
at Microsoft.ReportingServices.DataExtensions.CommandWrapperExtension.GetParameters()
at Microsoft.ReportingServices.QueryDesigners.QueryResultsGrid.CreateCommand()
May 12, 2008 at 11:09 am
Did anybody got the answer for tihs. I am getting same error
May 14, 2008 at 8:28 am
I am having same problem with SQL2005 stored procedure. The report works fine when I pass non query parameter.
When I use the query filed Parameter and deploy the report, I get the error message " An unexpected error occurred in Report Processing. (rsInternalError) Bad method token. "
Plz help.
June 2, 2008 at 10:32 am
Example:
EXEC StoredProcedureName @Parameter1, @parameter2,....
June 2, 2008 at 10:59 am
It will not work this way. Just put the proce name like exec proc, SSRS will automatically gathers input parameters and create parameters for the same
Kapil Gupta
June 2, 2008 at 11:04 am
I asked the admin to re-Install the SSRS . My Problem got resolved and the report is working fine with the query parameters.I did't make any changes to report.
June 2, 2008 at 11:08 am
Reinstalling is not the issue here but the way Oracle Ref Cursor is been handeled here in SSRS
Kapil Gupta
March 11, 2020 at 4:24 pm
Did anyone get the solution for this.
We are struggling for the oracle stored procedures to work.
Any help Would be greatly appreciated.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply