Print all stored proc variables (Firebird)

inageib · Post by **inageib** » Sun 20 Nov 2011 00:32

Hi,
Is there a quick way to print all variables for a certain stored procedure after passing input parameter ?

AndreyZ · Post by **AndreyZ** » Mon 21 Nov 2011 13:43

Hello,

The point is that Firebird system tables do not contain information about stored procedures variables. That's why IBDAC cannot return this information.

inageib · Post by **inageib** » Mon 21 Nov 2011 22:37

so the only way is to return these variables as output parameters ?
or there a way to make a log while executing a proc ?
update:
I will make a memo field and update it with the variable values thats it

Thanks

AndreyZ · Post by **AndreyZ** » Wed 23 Nov 2011 12:01

It's good to see that you've found a solution. If any other questions come up, please contact us.