How to get stored proc input parameters and values by MDA tables in Sybase ASE 15.7?

Question

I am trying to get executed stored procedure input parameters and their values by using mda tables. I have used monProcessProcedures and monProcessSQLText but both tables are only returning proc name and not parameter names and values.

Please suggest.

Is there a reason you can't just look at the Proc itself and find the information? — Mike Gardner, Jun 01 '15 at 15:37

score 0 · Answer 1 · answered Jul 02 '17 at 07:26

The database hides the parameters from procedure calls and SQL queries in many situations. You can try the following approaches:

if you can modify the procedure code - run the procedure using statics parameters (like 'exec proc 1,2' - not using prepareStatement/PrepareCall)
run dbcc traceon(11202) - this would log all the ASE sql commands to the ASE errorlog - you may check if tour procedure parameters have also been logged
add addition comment to your procedure execution code with your parameters - they may be logged in monProcessSQLText

It seems that `dbcc traceon(11202)` does not show parameters. — DEWA Kazuyuki - 出羽和之, Apr 15 '19 at 02:59

How to get stored proc input parameters and values by MDA tables in Sybase ASE 15.7?

1 Answers1