PB中调用SQL Server存储过程

PB中调用SQL Server存储过程

DECLARE logical_procedure_name PROCEDURE FOR SQL_Server_procedure_name
@Param1 = value1, @Param2 = value2 ,
@Param3 = value3 OUTPUT,
{USING transaction_object}  ;

EXECUTE logical_procedure_name ;
IF transaction_object.SQLCODE = 0 THEN
ELSE
 Messagebox("EXEUTE",transaction_object.SQLERRTEXT)
END IF
FETCH logical_procedure_name INTO :XX ;

CLOSE logical_procedure_name ;