AdaBase.Statement.Base.[STMT] function
AdaBase.Driver.Base.[DB].call_stored_procedure (stored_procedure : String; proc_arguments : String)

This function will execute the stored procedure identified by the name indicated by the stored_procedure and use the proc_arguments to pass arguments to the stored procedure. This can be in the form of an empty string (no arguments), a single word (1 argument), or several words separated by commas (multiple arguments).

The first result set the executed stored procedure returns (if any) is returns by the call_stored_procedure function. Some procedures may return multiple result sets, and the subsequent ones can be accessed by the fetch_next_set function.

See stmt fetch next set for a usage example.

[DB] is "MySQL.MySQL_Driver" or "PostgreSQL.PostgreSQL_Driver"

[STMT] is "MySQL.MySQL_statement" or "PostgreSQL.PostgreSQL_statement"

See Also

  • stmt fetch next set
  • stmt fetch next row
  • stmt fetch bound
  • stmt fetch all