Suppose I have created a stored procedure in SQL Plus named spTry which retrieves all the records from a DB table. Now after exiting from the SQL Plus interface & then logging back in, how do I view the code of the stored procedure that I had created previously so that, if the need arises, I can make some changes in the stored procedure?
Also how do I execute the stored procedure so that all the records get retrieved & displayed in the SQL Plus interface similar to how the records get retrieved & displayed in the Query Analyzer using EXEC <ProcedureName> in SQL Server? EXEC <ProcedureName> in SQL Plus just displays PL/SQL procedure successfully completed!!
Thanks,
Arpan
Also how do I execute the stored procedure so that all the records get retrieved & displayed in the SQL Plus interface similar to how the records get retrieved & displayed in the Query Analyzer using EXEC <ProcedureName> in SQL Server? EXEC <ProcedureName> in SQL Plus just displays PL/SQL procedure successfully completed!!
Thanks,
Arpan