Executing an SQL Server stored procedure from events
Calling the procedure without parameters.
If stored procedure doesn't return the recordset:
DB::Exec("EXEC StoredProcNameHere");
If stored procedure returns the recordset:
DB::Query("EXEC StoredProcNameHere");
Passing one of the field values as a parameter:
$sql = DB::PrepareSQL( "EXEC StoredProcNameHere ':1'", $values["FieldName"] );
DB::Exec( $sql );
Executing MySQL stored procedure from the event
Calling the procedure without parameters.
If stored procedure doesn't return the recordset:
DB::Exec("CALL StoredProcNameHere");
If stored procedure returns the recordset:
DB::Query("CALL StoredProcNameHere");
Passing one of the field values as a parameter:
$sql = DB::PrepareSQL( "CALL StoredProcNameHere ':1'", $values["FieldName"] );
DB::Exec( $sql );
Executing ORACLE stored procedure from the event
Calling the procedure without parameters.
If stored procedure doesn't return the recordset:
DB::Exec("BEGIN STOREDPROCNAME(); END;");
If stored procedure returns the recordset:
DB::Query("BEGIN STOREDPROCNAME(); END;");
Passing one of the field values as a parameter:
$sql = DB::PrepareSQL("BEGIN STOREDPROCNAME(':1'); END;", $values["FieldName"]);
DB::Query($sql);
See also:
•Connecting to Oracle database
