Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2009 at 01:24 AM

    Found the answer myself

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.