OPEN CURSOR WITH HOLD in Native SQL

[Former Member]

Hi All,

I am fetching the data from Other SAP system by using Native SQL.

In Native SQL, I am using Open Cursor

But cursor is getting closed for second time if i wanted to fetch the data second time.

So I am planning to use WITH HOLD Option but it is not working.Could you please help us here.

[Former Member]

Native SQL is dependent on your database. So it's not possible to give a good answer without knowing that.

Rob

[former_member214857]

Hi

It depends on each database. One possiblity is use FOR UPDATE statement

Best regards

[Former Member]

HI ALL,

Native SQL checks for synatx errors in requests recieved and passes the request to database through gateway service.

depending on the DB,performance varies.

Regards,

Namitha.