How to view the exisiting procedure in oracle 8i and how to describe the procedure.
from user_source, all_source, dba_source
desc procedure_name in sql*plus
As Pando said, you can see it from User_Source, All_Source etc., but normally when you move your
application from development to production environment you should wrap the Pl/Sql stored objects, so that
others will not be able to see the source code of it.
Say No To Plastics
Use a tool like TOAD or PLSQL-developer
Ben de Boer
Click Here to Expand Forum to Full Width