Hi,

Is there any way to determine programmatically whether a parameter of an
existing stored procedure is OUTPUT without parsing the procedure's
source code? I'd like to use either a DB-Lib call or an SQL command to
do this. As far as I can see the DB-Lib calls like "dbretdata" and
others give you the info about return params AFTER you execute your
stored procedure. On the other hand in order to bind a parameter to a
variable using "dbrpcparam" I need to know if the parameter is OUT
before "dbrpcsend". I couldn't find anything helpful in syscolumns where
the "status" column doesn't tell if the param is OUT (as opposed to MS
SQL Server where it does tell).

Any help will be greatly appreciated.

David Bukhan