FB_DBStoredProcedures

FB_DBStoredProcedures 1:

With this function block FB_DBStoredProcedures you are able to start stored procedures. It is possible to declare parameters which will be used in the stored procedures.

VAR_INPUT

VAR_INPUT
    sNetID              : T_AmsNetID    :='';
    hDBID               : UDINT         :=1;
    sProcedureName      : T_MaxString   :='';
    cbParameterList     : UDINT;
    pParameterList      : POINTER TO ARRAY[0..MAX_STORED_PROCEDURES_PARAMETERS] OF ST_DBParameter;
    bExecute            : BOOL;
    tTimeout            : TIME          := T#15s;
END_VAR

sNetID : Is a string containing the AMS network identifier of the target device to which the ADS command is directed.

hDBID : Is the ID of the database to be used.

sProcedureName : Provides the name of the stored procedure.

cbParameterList : Provides the size of a parameter list in bytes.

pParameterList : Provides the address of a parameter list.

bExecute : The command is executed with the rising edge.

tTimeout : Indicates the duration of the timeout.

VAR_OUTPUT

VAR_OUTPUT
    bBusy       : BOOL;
    bError      : BOOL;
    nErrID      : UDINT;
    sSQLState   : ST_DBSQLError;
END_VAR

bBusy : The command is in the process of being transmitted by ADS. No new command will be accepted if "bBusy" remains TRUE.

bError : Becomes TRUE, as soon as an error occurs.

nErrID : Supplies the ADS Error Code or the TcDatabaseSrv_Error_Codes when the bError output is set.

sSQLState : Supplies the SQL error code of the specified database type.

Requirements

Development environment	Target system type	PLC libraries to be linked
TwinCAT v2.10.0	PC or CX (x86)	TcDatabase.Lib (from TcDatabaseSrv Version 1.0.13)
TwinCAT v2.10.0	CX (ARM)	TcDatabase.Lib (from TcDatabaseSrv Version 1.0.13)