on 12-17-2018 6:06 PM
Hi All,
I am posting this after unsuccessful searching of various posts. I am using below statement in my AMDP method.
SELECT VALUE INTO lv_value FROM ZBCP WHERE ZZPARID = ‘SIMU’ AND ZZPARGR = ‘END_DATE’;
In the above query am trying to get a value into the scalar variable lv_value in the field VALUE from the table ZBCP.
I will be using this variable in join conditions of a query which will be coming after this.
But the thing is am getting exception “Invalid column index(3)” on the above query. When doing the analysis I found that there no data for the above query for the given condition. So ideally variable should get a blank value when is there is no data maintained in above parameter table which is expected but it is throwing exception.
I tried using EXIT HANDLER with NO DATA error code also but no luck.
Please let me know how to solve this issue.
Thanks
Rithika
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.