Recent content by Pzz

The problem is in PL/SQL (the Oracle packages). In a SQL Window it seems to work fine.

If I use xmlnamespaces with double-quotes (") around the identifier the beautifier casues an error. If I remove them the beautifier works fine. For the use of identifiers like "StUF" (mixed upper- and lowercase) then double-quotes are necessary to read the XML. The code works, just the...

Ok.

When editting a package I can hardly see which procedure is higlighted in the leftside procedurelist. The highlight backgroundcolor is a grey/white on a white background. Where can I change this?

Ok, something for the wishlist... Thanks.

In the command-window (9.0.6.1665) I try SQL> SET DESCRIBE DEPTH 2; resulting in "Cannot SET DESCRIBE" It seems to work fine with SQL*Plus: Release 10.2.0.1.0 (no error) Other SET functionality seems to work fine (I don't use it often, I just found this one in the manual for describing objects)

Table is created by AQ as: begin sys.dbms_aqadm.create_queue_table( queue_table => 'MHZ_QUEUE_TABLE', queue_payload_type => 'MW4MHZ.MHZ_BERICHT_TYPE', sort_list => 'ENQ_TIME', compatible => '10.0.0', primary_instance => 0, secondary_instance => 0, storage_clause =>...

I just did. No changes....

I also have a "normal" table with an XMLTYPE as a fieldtype, and selects on this table works fine in a SQL-window.

I get an "Error ORA-04043 object MW4MHZ.XMLTYPE does not exist" when I select from a queue-table in the SQL-window. The same select works without a problem in the command-window. The queue-table is working fine and no problems with Advanced queueing. The queue-table is based on queue...