Could u plz tell me how to insert the data into oracle system with native s

31 Views

Hi all,

Could yo plz tell me how to insert the data that exists in my internal table into oracle system using native sql statement.

My Exact Requirement is I have the Data in my internal table say IT_ORD_HDR

(say 10 records exist).

The problem is i am going into dump with this SQL statement.

LOOP AT IT_ORD_HDR INTO WA1.

EXEC SQL.

INSERT INTO S_STB_BCL_ORDER_HEADER

(ORDER_NUMBER

ORDER_TYPE,

PROCESSING_STATUS,

CUSTOMER_LANGUAGE,

CUST_SOURCE_ACCT_NB,

SHIP_METHOD_ID,

CURRENCY_CODE,

DIST_SOURCE_ACCT_NB,

PAYMENT_TYPE,

DIRECT_FLAG,

ORDER_DATE,

REQUESTED_SHIP_DATE,

PO_NUMBER,

TOTAL_AMOUNT_WITH_TAX,

COMMENTS,

EAI_PROCESSING_DATE)

VALUES (:WA1-BAICAL_ORDER_NUM,

:WA1-ORDER_TYPE_ID,

:WA1-PROCESS_STAT_ID,

:WA1-LANGUAGE_CODE,

:WA1-CUST_ACC_NUM,

:WA1-SHIP_METHOD_ID,

:WA1-CURRENCY_CODE,

:WA1-DIST_ACC_NUM,

:WA1-PAYMENT_TYPE_ID,

:WA1-DIRECT_FLAG,

:WA1-ORDER_DATE,

:WA1-ORD_REQ_DEL_DATE,

:WA1-PO_NUMBER,

:WA1-TOTAL_PRICE_TAX,

:WA1-ORDER_COMMENTS,

:WA1-EAI_PROCESS_DATE);

ENDEXEC.

Is there anything syntactically wrong in my Native SQL statements, If so Plz rectify me. But i am going into dump during execution.