03-09-2009 10:30 PM
Hi,
I want to get a recordset being returned by an oracle stored procedure directly into an internal table
types: begin of type_cfgi,
kunnr type kunnr, "END_CUSTOMER_NUMBER NUMBER
cust_name(60) type c, "NAME1_GP, "END_CUSTOMER_NAME VARCHAR2(80)
lgort type lgort_d, "STORAGE_LOCATION VARCHAR2(80)
matnr type matnr,
orig_qty type kwmeng, "ORIGINAL_QTY NUMBER
avl_qty type kwmeng, "AVAILABLE_QTY NUMBER
all_qty type kwmeng, "ALLOCATED_QTY NUMBER
end of type_cfgi.
data: t_cfgi type STANDARD TABLE OF type_cfgi.
EXEC SQL.
execute PROCEDURE scmp4_1.zpkg_ipn_pdad.zpro_ipn_Get_CFGI_Values
(out :v_return,
out :t_cfgi)
ENDEXEC.
however it gives me an error
The DSQL interface was called with invalid parameters. I also tried making all the variables to char in the internal table. For some reason the oracle people dont want me to fire a direct query or open cursor from in native SQL in SAP. So that option is off the table.
09-10-2009 2:24 AM