Recent content by molloycp

Marco, I pointed my oracle home in the tool to OraHome92 and the OCI to C:\oracle\ora92\bin\oci.dll and it now works......yay Seems like it is due to some strange configuration of multiple oracle homes on my oracle client. Thanks Chris

Just tried it and it did not fix the problem. Any other ideas?

Hello, A simple select from a table that has a few fields of type TIMESTAMP(6) WITH TIME ZONE Results in an error of ORA-01877 : string is too long for internal buffer We're running Version 7.1.5.1398 on oracle version 10.2.0.3.0 Do we need to upgrade our PLSQL Developer? Chris

Hello, Is there any way to sort the column names within a table in the object browser other than ordering them within the table definition? Chris

For example, try this query without beautifying first. Chris select 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 from dual where 14 in (14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53...

Hello, I have a sql query that extends beyond 256 lines. When I export to excel, the SQL code in the SQL Statement tab appears to truncate the code after 254 lines. Is this a known issue? I'm using version 7.0.2.1076 Chris

I was just looking though old posts with respect to browser performance issues and noticed this one. I had previously posted about abnormal delays when expanding table columns in the object browser and all other related areas such as query builder. I still experience the same delays, I also...

Tried changing to single session. It had no effect on the response time. I will talk to the DBA to see if there are performance problems with the dictionary views. However, I run SQL Navigator as well, and there are no delays when getting info from the dictionary so it may be a difficult problem...

I tried the largest table (210 fields) and it took 1 minutes 35 secs after selecting "view" for the info to come up. There are no foreign keys for this table. Any ideas on what could be causing this type of response? Is/has anyone else experienced this and resolved it?

Thanks for the quick reply. I tried using the DBA views as suggested and limiting my browser window, but it had no effect. In query builder, when I select a 2 field table it takes 8 seconds for the table to appear. A 22 field table takes 40 seconds, a 210 field table takes 3 minutes and 50...

Just starting using PL/SQL Developer, so please be patient. When selecting tables in Query builder, I'm experiencing extrememly long waits for the tables to actually appear. So long that it makes working with query builder impossible. In the object browser, I've learned not to "expand all" as...