topic Re: native SQL - execute procedure - using open cursor in Application Development and Automation Discussions

native SQL - execute procedure - using open cursor

Former Member — Wed, 21 Jan 2009 15:54:21 GMT

Hi,

I would like your help in the following


  exec sql.
      execute procedure d01.Z_PRICINGREPORT ( IN :v_symandt, IN :v_kschl )
  endexec.

I would like to get the output in a cursor. The following code is giving a native SQL exception.


  exec sql.
    open dbcursor for
      execute procedure d01.Z_PRICINGREPORT ( IN :v_symandt, IN :v_kschl )
  endexec.

Warm Regards,

Abdullah

Re: native SQL - execute procedure - using open cursor

ThomasZloch — Wed, 21 Jan 2009 16:03:59 GMT

Thomas

Re: native SQL - execute procedure - using open cursor

former_member194669 — Wed, 21 Jan 2009 16:11:53 GMT

I think while calling stored procedure you need to specify whether the parameters are output (OUT), input (IN), or input and output and not on CURSOR.

Please check the SAP Note : 44977

a®

Re: native SQL - execute procedure - using open cursor

Former Member — Wed, 21 Jan 2009 16:13:59 GMT

Moreover, If I specify it in the following way


open dbcursor for 
EXEC d01.Z_PRICINGREPORT '210' 'ZPRE'

it fetches the result but when i specify the parameters in the following way, the query executes with return code 0 but no records are fetched in the cursor.


open dbcursor for 
EXEC d01.Z_PRICINGREPORT v_symandt, v_kschl

v_symandt contains the client

v_kschl contains the condition type

Regards,

Abdullah

Re: native SQL - execute procedure - using open cursor

Former Member — Thu, 22 Jan 2009 06:23:19 GMT

Hi Experts,

can anyone suggest how to execute a procedure and get the resultset in a cursor using native sql?

Warm Regards

Re: native SQL - execute procedure - using open cursor

Former Member — Thu, 22 Jan 2009 06:33:39 GMT

Hi,

Please check if it helps you:

Regards,

Rahul

Re: native SQL - execute procedure - using open cursor

Former Member — Sun, 25 Jan 2009 16:00:34 GMT

Hi Experts,

The issue has not been resolved till now. I tried making a view in the database and querying. It is also degrading performance. I would like to call the stored procedure. Please let me know if it is possible.

Warm Regards,

Abdullah.

Re: native SQL - execute procedure - using open cursor

Former Member — Thu, 12 Mar 2009 13:54:56 GMT

the SAP demo program ADBC_DEMO helps

Re: native SQL - execute procedure - using open cursor

Former Member — Wed, 29 Jul 2009 23:07:36 GMT

If you use the host variable syntax (preceeding colon) it works eg. EXEC d01.Z_PRICINGREPORT :v_symandt, :v_ksch

Regards

Peterl

Re: native SQL - execute procedure - using open cursor

Former Member — Thu, 20 Aug 2009 02:04:13 GMT

hi,ZAFCO ABAP

the issue has been resolved?

i think i have met the same issue .There is a Oracle pl/sql stored procedure ,it's have a output parameter of oracle's cursor type,by calling this stored procedure i can get a resuletset.Then,i tried coding as below:

DATA dbcur TYPE cursor

EXEC SQL.

EXECUTE PROCEDURE SP_TEST(out :dbcur)

ENDEXEC.

by notes 44977 i tried as below:

EXEC SQL.

open cr for PROCEDURE SP_TEST(out :dbcur)

ENDEXEC.

But both of above did not resolve it.Pls help me if you have been out of the issue. thanks!

Re: native SQL - execute procedure - using open cursor

Former Member — Tue, 29 Mar 2016 07:28:04 GMT

This message was moderated.

Re: native SQL - execute procedure - using open cursor

Former Member — Tue, 29 Mar 2016 07:29:55 GMT

This message was moderated.