RE: PLSQL stored procedure

[David . Schmoldt]

Title: Message

The freeware version of TOAD isn't on the Quest web site.  Try www.toadsoft.com instead.

 

And no, it doesn't have the debugger.  You have to buy the TOAD XPert version for that. 

 

But free TOAD is still an extremely nice Oracle tool for working with the database, editing PL/SQL procedures. running queries, etc.

 

Dave

 

-----Original Message-----
From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: PLSQL stored procedure

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-----
From: Nick Wagner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: PLSQL stored procedure

our go get TOAD freeware...  even has a line by line debugger with watches.

-----Original Message-----
From: Darrell Landrum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 05, 2003 7:06 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: PLSQL stored procedure

Look at user_source (or all_source if the procedure is in a different schema).
Then
select text from user_source where name = 'YOURPROCNAME';

>>> [EMAIL PROTECTED] 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.net
--
Author: Adrian Ciocildau
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Darrell Landrum
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).