SQLProcedures (level two only)

SQLProcedures returns the list of procedure names stored in a specific data source.

Procedure is a generic term used to describe an executable object, or a named entity that can be started with input and output parameters, and which can return result sets similar to the results that SELECT statements return.

The following table describes the SQLSTATE and error values for SQLProcedures.
SQLSTATE Error value Error message
01000 -11001 General warning
08S01 -11020 Communication-link failure
24000 -11031 Invalid cursor state
S1000 -11060 General error
S1001 -11061 Memory-allocation failure
S1008 -11065 Operation canceled
S1010 -11067 Function-sequence error
S1090 -11071 Invalid string or buffer length
S1C00 -11092 Driver not capable
S1T00 -11094 Time-out expired
S1C00 -11300 SQL_DEFAULT_PARAM not supported
08S01 -11301 A protocol error has been detected. Current connection is closed.
S1000 -11310 Create and Drop must be executed within a ServerOnly Connection
S1000 -11320 Syntax error
S1000 -11323 The statement contained an escape clause not supported by this database driver