Oracle/DB22010. 9. 10. 11:28


/*--------------------------------------------------------------------------------------------------*/
Transaction          SQLSP

SQLSP = create Transaction
SQLSP.DBMS = "ODBC"
SQLSP.AutoCommit = False

SQLSP.DBParm =  "ConnectString='DSN=" + gs_system + ";UID="+ gs_emp_no +";PWD="+ gs_password + "'"

CONNECT using SQLSP;

//SQLSP Connection Check!
if SQLSP.sqlcode <> 0 then
 Messagebox ( 'SERVER CONNECT ERROR', 'Connect Fail' + " Connection Error" )
 Return
end if

//Stored Procedure 실행
DECLARE SP_USER_ENABL PROCEDURE FOR SP_USER_ENABL(:ls_nno, :ls_rst, :ls_msg) using SQLSP;
EXECUTE SP_USER_ENABL;

DISCONNECT using SQLSP;

Posted by Julyus