Recent content by Cube874

  1. C

    Can't kill long running queries

    Any way to kill the session other than exit the application? Some days, this is fairly routine work.
  2. C

    Find/Replace in rectangular selection

    Version 7. It's unlikely we'll be upgrading until this current development effort is over. (and I think we mean the same thing when we talk about "column selection" and "rectangular selection" ;) )
  3. C

    Can't kill long running queries

    I have some queries that take several minutes to run (anywhere from 5 to 15). If I try to kill them by clicking the "Break" button, or by typing "Shift-Esc.", nothing happens. The only way to terminate the query is to try to exit the application. Usually I have to wait about 30 seconds for the...
  4. C

    Find/Replace in rectangular selection

    I've tried doing a find/replace in a rectangular selection area and I keep getting a problem where PL/SQL Dev runs at about 50% CPU and needs to be killed via the Task Manager. Is this a known issue? Are there workarounds?
  5. C

    Export table with XMLType column

    The XML contents are significantly larger than 4000 bytes. I am storing XSL files for transformation. I need to be able to create DDL and DML scripts that will recreate the application. Any other tips?
  6. C

    Export table with XMLType column

    I have a table that has a column that is an XMLType. I need to export the data as a DML but when I try to export using "SQL Inserts" or "PL/SQL Developer" type exports, I get an error: "Table [TABLE] contains one or more XMLType columns. Cannot export in SQL format." I tried usingt the Oracle...
  7. C

    Too many windows?

    I have only been doing project builds. Not sure if/when I'll be able to try in 8.x.
  8. C

    Too many windows?

    I've noticed that when I have many windows open (more than 10) and the WindowList is visible, compiling seems to take a lot longer and the application window flickers a lot more. Anyone know what's up with that? Also, the compiler progress window stays on top during long compiles, even when...
  9. C

    8.0.1 Data Generator bug fixes

    I'm not sure if I encountered this. How did it manifest itself?
  10. C

    8.0.1 Data Generator bug fixes

    Hello, We may consider upgrading to 8.0.1, but the thing we're most interested in is if there have been any major fixes/improvements/changes to the Data Generator tool. I don't like changing to a new version in the middle of a development effort, but if there has been work done on the Data...
  11. C

    Data Generator - pre-existing data

    Possibly... I'll check. It might take some time. Having the Data Generator execute a query for the list would be quicker and easier for me! ;)
  12. C

    Data Generator - master/child tables, table ordering, feature request

    Another strange issue with the data generator: I have two parent tables, A and B. They do not depend on each other, but have the SAME dependencies on two other tables. I have several child tables. Some of the children depend on A, and some on B, and some on both. For tables that depend on A, I...
  13. C

    Data Generator - pre-existing data

    Is it possible to populate fields in the data-generator with pre-existing data? Some of the data has already been created and it would be much easier (and quicker) to just run a query (or better yet, call a function that I write) to retreive the correct reference value than to write and run...
  14. C

    put_line cannot print more than 2000 characters

    Hello, having some trouble printing to the console when the string I'm printing has > 2000 characters. An example script is: set serveroutput on size 100000; declare big_str varchar2(2009); begin for i in 1..2009 loop big_str := big_str||'x'; end loop...
Back
Top