Hello!

I made dw using procedure
My Powerbuilder application run on appeon and this appeon is connected with tibero DB.
I can not get result in my this dw.
this dw working well in oracle.
my dw source is like follow.

plz kindly infrom me how to all procedure which inculde SYS_REFCURSOR in appeon connected with tibero(DB)

1) dw source
table(column=(type=char(20) updatewhereclause=no name=gubun dbname="GUBUN" )
 column=(type=char(20) updatewhereclause=no name=trade_desc dbname="TRADE_DESC" )
 column=(type=decimal(0) updatewhereclause=no name=contract_amt dbname="CONTRACT_AMT" )
 column=(type=decimal(0) updatewhereclause=no name=estimate_amt dbname="ESTIMATE_AMT" )
 column=(type=decimal(0) updatewhereclause=no name=exe_real_contract_amt dbname="EXE_REAL_CONTRACT_AMT" )
 column=(type=decimal(0) updatewhereclause=no name=future_real_contract_amt dbname="FUTURE_REAL_CONTRACT_AMT" )
 column=(type=decimal(0) updatewhereclause=no name=exe_contract_amt dbname="EXE_CONTRACT_AMT" )
 column=(type=decimal(0) updatewhereclause=yes name=future_contract_amt dbname="FUTURE_CONTRACT_AMT" )
 column=(type=decimal(0) updatewhereclause=yes name=total_future_contract_amt dbname="TOTAL_FUTURE_CONTRACT_AMT" )
 procedure="1 execute sca_sp_trade_list_report;1 @p_SITE_CODE = :SITE_CODE, @p_YYYYMM = :YYYYMM" arguments=(("SITE_CODE", string),("YYYYMM", string)) )

2) procedure source
CREATE OR REPLACE PROCEDURE SCA_USER."SCA_SP_TRADE_LIST_REPORT" (
 p_SITE_CODE CHAR
 , p_YYYYMM CHAR
 , cur_out OUT SYS_REFCURSOR)
 
AS
BEGIN

 ~~~~~~~~ (omit)

  OPEN cur_out FOR
      SELECT
       GUBUN  
       ,TRADE_DESC
       ,CONTRACT_AMT
       ,ESTIMATE_AMT
       ,EXE_REAL_CONTRACT_AMT
       ,FUTURE_REAL_CONTRACT_AMT
       ,EXE_CONTRACT_AMT
       ,FUTURE_CONTRACT_AMT
       ,TOTAL_FUTURE_CONTRACT_AMT
      FROM TEMP_TRADE_LIST_REPORT_TAB1
      UNION ALL
      SELECT
       ''  
       ,'total(sum)'
       ,NVL(SUM(CONTRACT_AMT),0)
       ,NVL(SUM(ESTIMATE_AMT),0)
       ,NVL(SUM(EXE_REAL_CONTRACT_AMT),0)
       ,NVL(SUM(FUTURE_REAL_CONTRACT_AMT),0)
       ,NVL(SUM(EXE_CONTRACT_AMT),0)
       ,NVL(SUM(FUTURE_CONTRACT_AMT),0)
       ,NVL(SUM(TOTAL_FUTURE_CONTRACT_AMT),0)
      FROM TEMP_TRADE_LIST_REPORT_TAB1
      WHERE ITEM_NO IN (103, 12, 13);
END;