Getting info about SP parameters 
Author Message
 Getting info about SP parameters


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

Sat, 11 Mar 2000 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Parameters passed to SP getting messed up.

2. Not getting Output parameter From SP

3. Check if parameter supplied to SP inside SP

4. Optional Parameters to SP - no value, one, or several values per parameter

5. Oracle SP Parameter Error - Invalid Parameter Type

6. deciphering the @@version info to get the SP version

7. conflicting info on sp's


9. Getting DBCC Commands to Return Rows Instead of Info Messages

10. getting table info in odbc

11. Getting failure info from msmdarch.exe

12. Getting connection info

Powered by phpBB® Forum Software