Jdbc Store procedure error

[Former Member]

Hi All,

I am using a sender JDBC adapter to execute a store procedure .i have used the Query as

Query SQL statement = EXEC Storeprocedurename

i am getting an error as the Store procedure could not be found in the SQL server, but when i check in SQL i am able to see the procedure and able to execute it also.

In the database i see the stored procedure name as "xyz.Storeprocedurename" i tried using this name also but i am getting the same error.

can anyone please suggest how to resolve this error.

Thanks,

Hemanth.

[Former Member]

Hi Hemanth,

What is the complete requirement? Are you sending some data as input to the SP? If yes then y dont u execute the stored procedure using receiver JDBC adapter and if you are retreiving data from stored procedure, you can call the SP in synchronous mode.

Can you please explain end to end flow of your requirement.

Thanks

Ajay

[Former Member]

Could you please give the exactly error?

[Former Member]

Try with these entries:

Query SQL statement: execute userid.StoreProcedureName

Document Name: Sender Message Type

Document Namespace: Sender Namespace

Update SQL Statement: <TEST>

Hope this helps,

Ravi