Two questions

Hello,

Please pardon me if these questions have been asked before: 1. How can I have a list of all the triggers that are attached to my tables?
Can I do this at the SQL*Plus prompt?

2. When I execute a stored procedure, how do I get the output? For example, declare procedure sp_test (v_name in varchar2,

                                  n_number out number) is
                         begin
                                  ...
                                  select amount into n_number
                                  from my_table
                                  where condition;
                          end sp_test;

Now, I execute the procedure. Where does the ouput go? How do I catch the output?

TIA, Songmuh Received on Thu Jan 29 1998 - 00:00:00 CST