Recent content by S_G

I have yet to upgrade to 12.04 but when I upgraded from 12.02 to 12.03 I lost all the icons that I added to the quick access toolbar. Is it possible to save these shortcuts upon upgrade.

create table test_table2 (xmltext xmltype) xmltype column xmltext store as binary xml; declare v_num number := 0; begin while v_num <= 100 loop insert into test_table2 values (xmltype ('<dataset><data>hello</data></dataset>')); v_num := v_num + 1; end loop; commit...

All the code blocks I have placed above have been run in a SQL window. Do you have a type in your second sentence? Select not nulls and see if null appear?

Also happens in Build 1762

As in this ? If so no issues on 10g/11g client. CREATE TABLE test_table2 (xmltext XMLTYPE) XMLTYPE COLUMN xmltext STORE AS BINARY XML; INSERT INTO test_table2 VALUES (null); INSERT INTO test_table2 VALUES (xmltype(null)); COMMIT; -- 10G No issues -- 11G No issues SELECT * FROM test_table2...

We have come across this issue also but what it was not happening to all. After some investigation we were able to replicate the error on a machine that was not receiving the value error. The difference between the two was the client used by PL/SQL Developer to connect to the database. The...