I downloaded trial version 6.0.5.931 of PL/SQL Developer. I have a pipelined table function, which returns records containing a number of 'normal' columns, and one column of type XMLType.
Now, when I query this function in the SQL window:
select * from table(f_my_table_function(100, 200))
..it all works fine. But when I execute that query a second time, I get the following error:
"Access violation at address 01FBE7C1 in module 'orageneric10.dll'. Write of address 00000000"
After this, I cannot close the SQL Window or close the application, since PL/SQL Dev thinks the query is still running - Ctrl-Alt-Del is the only way out.
When I remove the XMLType column from the resultset, the error does not appear. When I execute a query on a normal view containing an XMLType column, the error does not appear.
What gives?
TIA,
Arno.
Now, when I query this function in the SQL window:
select * from table(f_my_table_function(100, 200))
..it all works fine. But when I execute that query a second time, I get the following error:
"Access violation at address 01FBE7C1 in module 'orageneric10.dll'. Write of address 00000000"
After this, I cannot close the SQL Window or close the application, since PL/SQL Dev thinks the query is still running - Ctrl-Alt-Del is the only way out.
When I remove the XMLType column from the resultset, the error does not appear. When I execute a query on a normal view containing an XMLType column, the error does not appear.
What gives?
TIA,
Arno.
