FORM get_data .

  gv_sdate = s_budat-low.
  gv_edate = s_budat-high.

  TRY.

    EXEC SQL.
      connect to :con_name
    ENDEXEC.

    IF sy-subrc NE 0.
      RAISE EXCEPTION TYPE cx_sy_native_sql_error.
    ELSE.

      EXEC SQL.
        OPEN DBCUR FOR
                SELECT SEQ_NO, REPAY_DATE, BANK_CD, ACCNT_NO,
                       ACCNT_NM, REPAY_DIV, REPAY_AMT, ORD_NO,
                       PAY_DIV, ID, ORD_NM, ORD_DATE,
                       ORD_AMT, PAY_DATE, PAY_AMT, BANK_NM
                FROM con_name.ORDM_11
                WHERE REPAY_DATE BETWEEN :GV_SDATE AND :GV_EDATE.

      ENDEXEC.

      CHECK sy-subrc = 0.

      DO.
        EXEC SQL.
          FETCH NEXT DBCUR INTO
                                :LS_BASE-SEQ_NO,
                                :LS_BASE-REPAY_DATE,
                                :LS_BASE-BANK_CD,
                                :LS_BASE-ACCNT_NO,
                                :LS_BASE-ACCNT_NM,
                                :LS_BASE-REPAY_DIV,
                                :LS_BASE-REPAY_AMT,
                                :LS_BASE-ORD_NO,
                                :LS_BASE-PAY_DIV,
                                :LS_BASE-ID,
                                :LS_BASE-ORD_NM,
                                :LS_BASE-ORD_DATE,
                                :LS_BASE-ORD_AMT,
                                :LS_BASE-PAY_DATE,
                                :LS_BASE-PAY_AMT,
                                :LS_BASE-BANK_NM
        ENDEXEC.

        IF sy-subrc <> 0.
          EXIT.
        ELSE.
          APPEND ls_base TO it_base.
        ENDIF.
      ENDDO.

      EXEC SQL.
        CLOSE DBCUR
      ENDEXEC.

      EXEC SQL.
        disconnect  :con_name
      ENDEXEC.

    ENDIF.

 

    CATCH cx_sy_native_sql_error.

  ENDTRY.

오류 로그

Runtime Errors         DBIF_DSQL2_SQL_ERROR
Exception              CX_SY_NATIVE_SQL_ERROR

Short text
    An SQL error occurred when executing Native SQL.

어떤 문제가 발생했습니까?
    The error 919 occurred in the current database connection "CON_NAME".

- 타 시스템에 있는 임의의 오라클 테이블 접속(ORDM_11)을 할려구 합니다

  그런데 어떤것은 접속이 되어 READ가 가능하지만 어떤건은 처리가 되지 않습니다 

- 접속해서 처리할수 있는 방법이 있는지 고수님들의 의견 부탁드립니다

- SAP에 혹시 테이블에 대한 권한을 줘야 하는 건지