How do I start!

[topstar]

Am a newbie, just downloaded Trial version of PL/SQL developer after reading about it.

But I am in a fix! After connecting to a local database, I find the browser lists all the procedures and packages, but I am not able to open them ! I noticed that there is a templates window in the browser, and when I click any item in the template it says "no editor available to accept text". Apart from this there is no friendly info anywhere to tell me what to do. Have searched all possible stuff on the software before putting this on board.

Please can someone tell me, with this problem, how do I open a procedure and carry out some work on it after I log into a database?

 

[ScottMattes]

Originally posted by topstar:
Am a newbie, just downloaded Trial version of PL/SQL developer after reading about it.

But I am in a fix! After connecting to a local database, I find the browser lists all the procedures and packages, but I am not able to open them ! I noticed that there is a templates window in the browser, and when I click any item in the template it says "no editor available to accept text". Apart from this there is no friendly info anywhere to tell me what to do. Have searched all possible stuff on the software before putting this on board.

Please can someone tell me, with this problem, how do I open a procedure and carry out some work on it after I log into a database?

To view/edit a package you need to right click on one and select either View or Edit. Or any of the other options.

Lots of things are right click, so right click everywhere to see what you can do.

To use the templates you need to start a SQL or Program window. There is an icon on the main toolbar on the far left side that if you hover the cursor over it says New. There is also the main menu File / New way to start a window.

------------------
------------
Scott Mattes

 

[topstar]

Ok Thanks for this help.

I have opened the package now. My main interest in downloading PL/SQL developer was to see if the PL/SQL Beautifier can help me in beautifying some of the most horrendously indented code I have ever seen in my life! The code itself is too big and there are so many begin,exceptions and ends all nested that it is impossible to check out where one ends and the other begins.

I however find that the in the menu, Edit->PL/SQL Beauitifier is disabled and only PL/SQL Beautifier Options is enabled.

So

1. Is it possible in PL/SQL developer to indent code automatically in order to get a clear understanding of those multiple and nested begins and ends?

2. If so how do I do it? Because as I said PL/SQL beautifier is disabled in the menu.

Cheers

PS: This is a downloaded trial version I am working on

 

[rbrooker]

make sure the package you are viewing is not read only

------------------
richard.brooker@vuw.ac.nz

 

[ScottMattes]

Did you right click and do View, or did you do Edit? This was the case for me when I just now tried it. Also, try saving to disk and closing all open windows and then open the file you just saved.

Also, PLSD has a very handy feature called something like Find Matching. Put your cursor on an 'if' and do ctl-m to find the 'end if'. It works on all pairs (begin/end, loop/end loop, etc). Very handy for inbedded IF constructs.

------------------
------------
Scott Mattes