| If... | Then... |
|---|---|
| stored procedures are not supported | the service will fail (return code 374). |
| are supported | a four-byte unsigned binary value is returned that indicates the maximum size of a data segment (in bytes). In such cases, if the size of the stored procedure exceeds this value, it must be sent as multiple requests, each of which sends data no larger than this value. |
The application sends the statements comprising a procedure to the database, where they are compiled and saved for subsequent execution. The application that creates the procedure must do the following:
- Ascertain whether the database supports stored procedures.
- Send a request containing the procedure that could exceed the maximum parcel size.
- Provide compilation options to the database.
To ascertain whether the database supports stored procedures, the CLIv2 Query service obtains the Server Maximum Segment Size. Based on the results returned by the Query service, one of the actions described in the next sections occurs.