Recent content by Kevin Herring

Not sure if this is a bug, but it is strange behaviour if not. Usually, in a package, I declare a method (function/procedure) in the package, and then the code appears in the package body. I have just discovered that you can have private methods, where the declaration goes in the top of the...

wow, I forgot all about this! Thanks Marco, thats brilliant.

Thanks chaps, thats brilliant.

Hi When I bring up the sessions window using the schema owner I can view the list of all the current sessions. However when I click on one of them the Cursors and SQl Text tabs at the bottom simply contain the text: ORA-00942: table or view does not exist Now I know this is just a...

Hi I am an oracle problem which I am hoping you might be able to help with. In my program at runtime, I get all the procedures in a package which the user can then run. Some of the procedures have parameters which the user enters, but some of these parameters are optional as they have a default...

when you include case statements in the where clause, the where clause and any additional statements after it all appear on the same line after beautification. e.g. WHERE t.description = CASE WHEN p_desc = 'ALL' THEN t.description ELSE p_desc END AND t.another_column = 'Y' AND...

Hi I love the feature in Developer where if your machine crashes, next time you load it up, it tells you you can recover the session. Firstly, I need some way of telling which server I was logged on to for that session so that I can select the correct one. When I had 4 copies of Developer...

Hi I do all my work over a VPN which has an annoyingly short timeout. In Putty and WinSCP there are options to send a null packet every 30 seconds or so to keep the connection alive. Would it be possible to add this option? As a side issue, I think that plsql dev handles connections closing...