Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Procedure

hussain_p
Participant
0 Kudos

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 ?

4 REPLIES 4

CarineTchoutouo
Product and Topic Expert
Product and Topic Expert
0 Kudos

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:

  • Getting Started:

Kind regards,

Carine

0 Kudos

Hi Carine,

Thanks for your reply

this is the st22 screen shot

i am using

SAP_BASIS7400010SAPKB74010SAP Basis Component
SAP_ABA7400010SAPKA74010Cross-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

jasmin_gruschke
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

0 Kudos

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 )