Skip to Content

HANA Procedure

Hi Experts,

i am creating procedure through graphical model as below screens

procedure is creatred , now i want to create database procedure proxy in abap  perspective as below sequence

click on activation button getting this dump/error

Please give me suggestions to solve the issue.

2) I am able to create procedure with table as input parameter .

     how to pass the values to table parameter , how to write the query based on input table inside procedure ?

proc1.jpg (48.1 kB)
proc2.jpg (131.4 kB)
proc3.jpg (52.9 kB)
PROC4.jpg (82.9 kB)
PROC5.jpg (66.5 kB)
PROC6.jpg (58.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 28, 2015 at 11:50 AM

    Hi Hussain,

    Can you provide the detailed information of the occured error (e.g. ST22)?

    Is there a special reason why you want to use a DB procedure proxy?

    On which AS ABAP 7.4 SPS are you working currently?

    Starting with ABAP 7.4 SPS05, the recommended approach is to use ABAP-Managed database procedures.

    Check here:

    Kind regards,

    Carine

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Carine,

      Thanks for your reply

      this is the st22 screen shot

      i am using

      SAP_BASIS 740 0010 SAPKB74010 SAP Basis Component SAP_ABA 740 0010 SAPKA74010 Cross-Application Component

      There is no special reason for database procedure proxy ,while exploring procedures i was stucked in this problem.i need to call procedure from abap.

      can we call the procedures in AMDP class.

      how to pass table as input parameter in procedure

      Thanks in Advance

      proc7.jpg (239.4 kB)
  • Oct 28, 2015 at 02:26 PM

    Hi Hussain,

    I agree with Carine, why not use AMDPs here :-).

    Yet, you've been asking for example coding. All this can be found in the ABAP Language Help:

    - ABAP Keyword Documentation (on DB Procedure Proxy Calls) and the corresponding example program in ABAP Keyword Documentation.

    Same holds for documentation about AMDPs, have a look at ABAP Keyword Documentation (and subpages).

    Best,
      Jasmin

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for your valuable information jasmin

      As you & Carine suggested we can use AMDPs here  but.. i would like to know what is the problem while creating database proxy .

      i think AMDP will not create the column views like procedures, which will be used reporting tools

      can we call column views in open sql(consuming external views in dictionary )