Use the following rules to run SQL stored procedures:
You can use binary values in character arguments. The argument cannot contain the 0 value, because the access service library sends all character arguments to ODBC as null terminated strings.
Do not use escape sequences, because the access service library does not support them. For example, “ABCD\n” is sent as a six-character string.
Character values sent in the use procedure statement can be longer than declared in the create procedure statement. Any extra characters are truncated, and no error message is sent.
If a numeric value has a larger scale than that in the target column, the argument is truncated, and no error is recorded.
When a select is issued as a SQL stored procedure, column names are not available. If the client requests column names, the access service library returns dummy names.
