on 05-12-2017 10:33 AM
Hello everyone,
I have one stored procedure below and its giving output in table as OUTTAB.
CALL "BI"."kgm.dtp.blt::Z_BLT_FWD_LOOP_10.05.2017"
(:IPBATCH,:IPPLANT,:IPMATERIAL,OUTTAB);
Now i m selecting data from OUTTAB in one more procedure 'Z_BLT_FWD_LOOP_09.05.2017'and getting new list of Materials, batches and Plant and want to pass it to original procedure('Z_BLT_FWD_LOOP_10.05.2017') again to get output.
But issue i am getting here is getting materials batches and plants in table form but i need to convert these table values into NVARCHAR input parameter values so that i can pass into original procedure.
Any pointers?
So below code i have written. (This is mine new procedure 'Z_BLT_FWD_LOOP_09.05.2017)
CALL"BI"."kgm.dtp.blt::Z_BLT_FWD_LOOP_10.05.2017"
(:IPBATCH,:IPPLANT,:IPMATERIAL,OUTTAB);
IPBATCH1 := ARRAY_AGG(:INPUT_NEW.CHARG);
BATCH_LIST = UNNEST(:IPBATCH1) AS ("V_BATCH"); --> How to pass these list of values again to above stored procedure ?
IPPLANT1 := ARRAY_AGG(:INPUT_NEW.WERKS);
PLANT_LIST = UNNEST(:IPPLANT1) AS ("V_PLANT"); --> How to pass these list of values again to above stored procedure ?
IPMATERIAL1 := ARRAY_AGG(:INPUT_NEW.MATNR);
MATERIAL_LIST = UNNEST(:IPMATERIAL1) AS ("V_MATERIAL"); --> How to pass these list of values again to above stored procedure ?
Br
Sumeet
User | Count |
---|---|
83 | |
11 | |
8 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.