how to test my stored procedures?

hi everybody.

 

i am writing stored procedures.

lots of them have out parameters.

 

i dont know how to test them

from an sql query tool(ex: pgAdmin query tool).

i am trying to test them from my program, but it is not so efficient.

 

i want to test from a query tool.

i can do with procedures without out paramters,

but how to achive with out parameters?

can i declare a variable out of procedure and

then send it as an out parameter and see it is value?

 

thanks for your help.