Our sample procedure prints the name of department 10
; the procedure takes no parameters, and returns no parameters. To create the sample procedure, invoke EDB-PSQL and connect to the Advanced Server host database. Enter the following SPL code at the command line:
property of the EDBCommand
object is used to indicate the type of command being executed. The CommandType
property is set to one of three possible CommandType
|Use the StoredProcedure
value, passing the name of a stored procedure for execution.
|Use the TableDirect
value when passing a table name. This value passes back all records in the specified table.
property must contain a SQL string, stored procedure name, or table name depending on the value of the CommandType