Recent content by NK

"Multi Session", and "Allow multiple connections" are the option settings here. Edit: SQL queries that take a long time to execute do not cause this "Window Not Responding"; only the Text Importer tool does.

If the GUI doesn't work to stop a query, I do the following to get a list of processes: SELECT s.inst_id, s.sid, s.serial#, p.spid, s.osuser, s.username, s.program, s.action FROM gv$session s JOIN gv$process p ON p.addr = s.paddr AND...

1. Save the file as a .csv (not .xlsx) 2. In PL/SQL Developer, go to Tools, Text Importer and open your .CSV file using Open icon. (notice it identifies your fields at the bottom) 4. Click on "Data to Oracle" tab, and name fill in the field names, table name, etc. 5. Click on Import...

Using Windows 7 Enterprise, 64-bit. While doing a Text Importer session, I see the PL/SQL Developer Window says (Not Responding) until the import completes. Is this normal?

I don't mean to digress, but I get about 800 rows/sec importing .csv files using the Text Importer tool.

The Text Importer is a great tool for creating a table out of a .csv file, but it pauses and expects human input if some row is problematic. I was importing 45 million rows, and 1 row was bad (missing comma), after 10 million rows, and it waited the whole night for user input before continuing...

Thanks! Your reply (from almost 3 years ago!) solved the problem I was having today with PLSD 7.1.5. If I was in debug mode, I click on the "Create Profiler report", and I click F9 to start running the procedure, I get "Profiler not supported in debug mode, report will not be created". If I...

Workaround: CREATE OR REPLACE PROCEDURE put_line(p_longLine IN VARCHAR2) IS -- Got most of this from a Google search -- Added maxLength to suit PL/SQL Developer 7.1.5 with Oracle 10.2.0.4 -- -- Now you can output a long string using this put_line, -- if DBMS_OUTPUT.PUT_LINE...

I wonder what is is about OCI in development tools... Using a value of 5000 crashed Toad 9.0 Using 32K from SQLPlus works fine. But SQL Developer (uses JDBC not OCI) can handle 32K. I am trying to convert blobs (1K - 2K) to a hexadecimal string (2K - 4K), to be used in an INSERT statement.

Thanks! I located that dialog, and set the default. But I don't have a "Filters" button. I see it under Tools, Browser Filters... But if I add that button to my toolbar (Tools, Preferences, Toolbar), clicking it does nothing.

Is there a way to make "My objects" the default (instead of "All objects") when PL/SQL Developer starts up? The reason I ask is because sometimes I forget to manually switch and click to expand all Tables, and it takes over 10 minutes (All objects), versus 5 seconds (My objects). (very large...

I would check if you have the basic components to connect to your database instance from your development machine. Seehttp://www.orafaq.com/wiki/Tnsping That has to work first. (It establishes if you have a valid Oracle setup there)

You are right. I am using 10.2.0.4 and it should support 32K I tried my sample code using 32762 instead of 1001, and it works using Oracle's SQL Developer v1.5.3 under Linux, going against the same database instance.

The error I receive is: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: as "SYS.DBMS_OUTPUT", line 148 ORA-06512: at line 2 I can even use 1000 instead of 255 with your example above, and it still works. But using 1001 causes it to fail.

-- I am using PL/SQL Developer v7.1.5 against Oracle 10.2.0.4 -- dbms_output.put_line() is supposed to handle 32K -- The second put_line() below fails, regardless of what I set the output buffer size to (in SQL Window). declare s varchar2(1001); begin s := rpad('x', 1001, 'x')...