Skip to Content
0
Former Member
Mar 09, 2009 at 10:30 PM

Want to get a recordset from oracle database directly into an internal tabl

32 Views

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.