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.
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 6-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.