10-28-2015 11:33 AM
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 ?
10-28-2015 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
10-28-2015 12:43 PM
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
10-28-2015 2: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
10-29-2015 4:24 AM
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 )