Recent content by Gaz

Hi Theod I know what you mean, but that not the issue I'm experiencing. From some objects (such as queue views) when I've run a query I get a returned column (which I think is what you're talking about and it has a text label and elipsis (...)) PNS_XML 1 ... 2 ... This will return a pop...

Hi I'm using 8.0.4 and am having trouble viewing XML objects in PL/SQL Developer, for example I create a table with one column of an xml type, insert some data, but on selecting from the table the GUI tool shows 1 row, but no information on screen. Is anyone else having this problem and is...

Thanks for the response.

Hi I'm currently using version 8.0.4 and have a query about the items such as Objects, Windows List and Files that you can unpin and hide in the toolbar on the left hand side of the screen. When PL/SQL Developer hides (minimizes) these, it shortens the name also making them difficult to read...

Hey I've noted that changing the session as above means that I'm not getting compilation warnings unfortunately. I can't seem to find a combination of manipulating PLSQL_WARNINGS that will remove the Hint, and keep all the (important) compilation errors. e.g. PLSQL_WARNINGS = 'ENABLE:SEVERE'...

That's worked great. Thanks.

Hi Thanks for the response, however this does not solve my issue, I was perhaps unclear, sorry. In a SQL window, if you hover over a package name while holding CTRL, it "hyperlinks" - however left (package spec) or right (package body) mouse click both then open in a new window as "File is...

Hi When I open a stored procedure or package via the CTRL+< mouse click> method, it seems to open things as Read Only. Is there an option I can set to make the new window an edit version, or toolbar option to switch from Read Only to Edit? Many thanks in advance Gaz

Brilliant - good call. We're waiting for our company to get version 8 approved before we're allowed to install. Turns out the company standard wrapped package comes with "ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';" in the AfterConnect.sql file - which would explain a thing or two! Thanks...

Thanks for the response. Is that a version 8 feature? I've got version 7 and "Compiler" doesn't appear to have an entry. Cheers Gaz

Hi I'm having trouble where to turn off compiler hints when compiling packages. I'm getting lots of PLW warnings that don't concern me - is there an option for turning this off? I looked at Tools > Preferences > Oracle > Hints {Profiler Hints} but this doesn't have anything that looks likely...

Ah I see, thanks for that.

Hi ALthough the help menu says that DESC is supported, whenever I try to use it in version 7.1, I get an ORA-00900 Invalid SQL statement error. Is there something I'm missing? I've tried with and without semicolon, backslash, putting it in a PL/SQL block even, highlighting the statement...

Thanks guys - patch - what's the set up executable that comes with the zip file for then? Marco - got template invocation working, cheers Thanks again Gaz

Thanks for the response, but regrettably when I attempt to install the plug-in I get a dialogue box saying installation failed, and no other log or information to determine what the issue might be.