Stored procedure with select query

[Former Member]

Hi,

I have a problem , We have a sysnchronous scenario and executing a stored procedure and a selcect statement .

it is running fine with little confilt in data is there.

We we run the scenario it execute the strored procedure and return the value like 500 and under select statement it select entire table which has same flag.

I want to execute stored procdure and in slect statement one row at a time and then again it will insert to other table in then database.

currently we are getting value like this.

<?xml version="1.0" encoding="utf-8" ?>

- <ns0:MT_SP_JDBC_response xmlns:ns0="http://ns_cfgCountry">

- <GetNextSiteNumber_response>

<Result>10000000000400</Result>

</GetNextSiteNumber_response>

- <Statement2_response>

- <row>

<ID>IN</ID>

<Description>INDIA</Description>

<GDate />

<FLAG>FALSE</FLAG>

</row>

- <row>

<ID>EN</ID>

<Description>ENGLAND</Description>

<GDate />

<FLAG>FALSE</FLAG>

</row>

- <row>

<ID>ZA</ID>

<Description>SA</Description>

<GDate />

<FLAG>FALSE</FLAG>

</row>

</Statement2_response>

</ns0:MT_SP_JDBC_response>

Regards

Laxmi Bhushan Jha

[Former Member]

Hi,

Can u please write your req little clear....

If you want to selcect and update a table and again select ... what ever it may be.... all these has to be done in the stored procedure only.

At the end of all ur statements u pass back the value from your Stored Procedure

Babu