error while executing the stored procedure through sender JDBC adapter

[Former Member]

Hi All,

I am getting below error while executing the stored procedure through sender JDBC adapter.

Database-level error reported by JDBC driver while executing statement 'exec SapgetNextEntity 'SalesOrder''. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.'. For details, contact your database server vendor.

what is the problem? any idea to anyone...

regards

Ramesh

[prateek · Accepted solution]

Either ur sql statement is incorrect or ur database does not have appropriate data for the executed stored procedure.

Regards,

Prateek

[Former Member · Accepted solution]

Hi Prateek,

The SP is giving result when I am execting it in MSSql Server, but not in PI through CC.

regards

Ramesh V

[Former Member]

Hi Problem is solved...problem is in SP only...sitting with the database people...I got to know...

regards

Rams

[Former Member]

Hi Ramesh,

  What is the issue with the Stored Procedure and how did you resolve it. Could you please let me know. Even I am executing an SP through PI sender JDBC channel. This SP is doing some update in the database and then it is selecting the required information.

Thanks,

Sarat

[Former Member]

Hi Ramesh,

I am facing the similar issue, can i know how this issue is resolved.

This is a production Bug, Could you please reply back ASAP.

Thanks,

--Sai

[Former Member]

Hi

Check with the stored procedure. Some how it is not the same as the select statement.

Regards

[Former Member]

monika

my SP is working fine in MSSql server. but not in PI...

regards

Rams..

[Former Member]

any idea to any one about above problem

[dharamveer_gaur2]

Have to seen stored procedure limitation

Stored porcedure can not return resultset, only can return one parameter.

Try to use Refrence Cursor it will return u reference of resultset.

[Former Member]

hi Dharamveer,

I am not getting below statement for your reply

Try to use Refrence Cursor it will return u reference of resultset.

I mention SP like this

exec SapgetNextEntity 'SalesOrder'

SapgetNextEntity -

---

> SP Name

SalesOrder----

---

> Parameter I am passing...

regards

Ramesh

[dharamveer_gaur2]

Check your connection parameter are ok

driver: oracle.jdbc.driver.OracleDriver

Connection url :jdbc:oracle:thin:@<ServerHostName>:<PortNo(1521 default)>:<SID>

[Former Member]

Hi Dharamveer,

I am using MSSql server and its working fine when I am executing Select statement instead of SP. But getting error while executing SP.

regards

Ramesh

[prateek]

Can you provide ur SQL statement (of CC) and stored procedure code. Make sure that the stored procedure has only one SQL statement (It can have a join statement).

Regards,

Prateek

[Former Member]

hi Prateek,

I mention SP like this

exec SapgetNextEntity 'SalesOrder'

SapgetNextEntity -

---

> SP Name

SalesOrder----

---

> Parameter I am passing...

Regards

Ramesh