Software

Ask something
Discussion Locked

Oracle-stored procedures

0 helpful
1 reply

by hamhey

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I must see the body and the specification of stored packeage in Oracle 9i database to modify the package according todo do things I need .
desc package_name shows the package sepecification.
My question is how to see the code of my own package or procedure to modify it.

Regards Hamid

1 reply

by draegor

The quick and dirty way is to go to
www.quest.com - Download the trial version of TOAD and install it. This will quickly allow you to do what you are wanting to accomplish. TOAD is a very powerful tool.

Good Luck.

This discussion is closed to new replies.