Recent content by admin

Thanks Claus, Glad to have your input on this also. To clarify, the problem was not HOW pld was displaying the column header but that pld would not display the SID column at all when selected in a detail tab query. As it turns out, when SID is selected by a query in a detail tab, pld will not...

Thanks, Theod, From comparing mine with yours I found that in order to make plsql developer show the sid column in a detail tab one must alias the SID column and also enclose the alias in double quotes. This works: select sid "sid" from v$session; These do not: select sid sid from v$session...

Hi Marco, I used the Cursors detail tab as my example above because I thought that would be a good example, however, I see now that maybe that was not a good example because that particular query is related to a particular sid that is already listed in the filter query. So here's a better...

Hi Marco, I'm afraid there is another bug. I believe this started right after I took the code update to 9.0.6.1665: In the session browser, on the Details tabs, the SID column no longer shows up in the output. I can run the same query from a SQL window and the sid column displays in there. This...

Thank you Marco.

Thanks - works very nicely. Sorry for the delay in the reply.

Hi Marco, I've been using plsql developer for some time now. Recently I've engaged with a different company and the company is considering purchasing plsql developer. I've been asked the question "How and where does plsql developer store database passwords?" this is an obvious concern. Please...

Hi, I'm trying to create a query to put into the details tab of the session browser that will present an explain plan for the sql for a selected active session. Looking for ideas as to how to approach this. Thanks in advance for any ideas.

Are you going to add that feature to the upcoming version 8? So far I cannot find it in PL/SQL Developer 8 Beta. Thanks. Andrew

Is it possible to have an option to ignore certain characters like whitespaces, quotations, etc. in "Compare User Objects"? Thanks. Andrew

Ara, I agree with you about collection debugging. It is pretty hard to debug PL/SQL code without that option. Andrew

I have upgraded to the latest version 7.1.5.1398. It looks like problem has gone. I will keep you posted when this happen again.

"Fails" means Compare Objects progress bar finishes pretty fast with no compare results. You are not allowed to exit Compare window ("...still busy" message pops up all the time).

Is PL/SQL developer 7.1 supports Oracle 8.1.7? One of our old clients got "ORA-24328:illegal atribute value" error. Do you have any advise with that one?

Compare two schemas: TEST1 to TEST2. Compare first time - schema objects from TEST1 and TEST2 - compare looks OK. Still at the same compare session - change schema to compare - compare schemas TEST1 and TEST3 - Compare FAILS. When trying to close Compare User Objects Window - error: "Compare...