Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'

[Krishna Gokidi]

Hi All,
I tried to call the stored procedure from java but I am getting Exception as : [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'sp_getNextMainGroup'

I checked the DB there 'sp_getNextMainGroup' is already exist, even checked the permision of user for the DB every thing is fine.
I unable to get the root cause of this Issue, can any one help me please.

Following the PrintStackTrace of the above Exception,


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'sp_getNextMainGroup'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at com.fmgtech.reports.HorPackageGen.getNextMainGroup(HorPackageGen.java:372)
at com.fmgtech.reports.HorPackageGen.run(HorPackageGen.java:176)

Thanks in Advance

[Scott Selikoff]

Please post the code you are using to make the connection. More often then not, its probably a permission/database issue; ergo, you're attempting to execute a stored procedure from a invalid context.

[Sachin Joshi]

Also make sure the number of parameters are same for your procedure....If it returns some value then you may need to have extra param for registering outParam in your code.

As Scott mentioned we can provide better idea if you post the code