Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PLSQL stored procedure
Jeremy,
The price for the TOAD Expert is quit reasonable when you consider the
fact that it includes the SQLab Expert module. The stand alone SQLab
Expert yearly fee was big $$$ and could only acces 1 server per license.
The TOAD expert can access many servers.
I changed over to the TOAD Expert and dropped the SQLab Expert module
last year. Saved a lot.
Ron
>>> Jeremy.Pulcifer_at_kadiri.com 03/05/03 03:34PM >>> Does the freeware version have the debugger now??!!!
If so, highly cool. Going to check right now.
Hmmm, no freeware TOAD version explicitly offered on website. Can
download
"trial" version of "Xpert Edition" (gotta love marketing and their
liberal
misuse of english)... WOW! 48 megs. My, how you've grown... I seem to
remember having a copy of TOAD on floppy back in the day. Might be
senility
setting in, though.
<wait_time: 20 minutes or so>
K, got the download, received email from quest with licenses. Ahah!
Only
good for 30 days.
! suppose I could point out that since a quest employee has declared
the
debugger as part of a freeware distribution, that maybe I shouldn't
have to
pay for it now, right?
-----Original Message-----
Sent: Wednesday, March 05, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
our go get TOAD freeware... even has a line by line debugger with watches.
-----Original Message-----
<mailto:DLANDRUM_at_zalecorp.com> ]
Sent: Wednesday, March 05, 2003 7:06 AM
To: Multiple recipients of list ORACLE-L
Look at user_source (or all_source if the procedure is in a different
schema).
Then
select text from user_source where name = 'YOURPROCNAME';
>>> adri_l_at_gmx.net 03/05/03 07:34AM >>> Hi.
i need some help. i'm trying to get a stored procedure source code
from
the database.
After a lot of reding i found :
select * from user_objects where object_type='PROCEDURE';
and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :(
please help,
adrian
-- Please see the official ORACLE-L FAQ: http://www.orafaq.netReceived on Thu Mar 06 2003 - 07:03:47 CST
<http://www.orafaq.net>
-- Author: Adrian Ciocildau INET: adri_l_at_gmx.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
-- Author: Darrell Landrum INET: DLANDRUM_at_zalecorp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
![]() |
![]() |