odbc_procedures

int odbc_procedures(resource conn, string catalog, string owner, 
string procedure) 

Displays procedure information.

Returns:

Result identifier; FALSE on error

Description:

Retrieves information about a procedure or procedures in a database. Instead of a procedure name, % can be specified as a wildcard or the underscore character (_) to match a single character.. The columns returned are PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, NUM_INPUT_PARAMS, NUM_OUTPUT_PARAMS, NUM_RESULT_SETS, REMARKS, and PROCEDURE_TYPE.

Version:

Existing since version 4.0

Example:

Display data from stored procedure
 $db = odbc_connect("DSN","user","pass"); $result = odbc_procedures($db,"Northwind", "dbo", "Employee Sales By Country"); odbc_result_all($result); ...

Get PHP Functions Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.