tiptop：呼叫SQL and DATE 轉換STRING

 
DEFINE p_date  DATE
DEFINE s_date  VARCHAR(10)

LET s_date = g_oea.oea02 USING "yyyy/mm/dd"
PREPARE s2 FROM "select ds.axmt410.get_oeb15(?,?) from dual"
EXECUTE s2 USING g_oea.ta_oea07,s_date INTO p_date
FREE s2


(axmt410.get_oeb15的參數都是VARCHAR2)