Recent content by gopi

Hello, v 7.0.2 question. How can I "explicitly continue the query" after getting the following message in a SQL window? My only choice on the screen is to click the OK. "Result set exceeds the maximum size (100 MB). If necessary, you can explicitly continue the query." Thanks much.

Hello, We are running 2 node RAC 9.2.0.4 on HP-UX. When we compile (F8) any and all stored procedures on node 1 we get an ora-600 [17113]. The 17113 argument means some kind of memory problem with 3rd party vendor. Node 2 compiles just fine the same procedures that were attempted on node1 -...

(PL/SQL Developer 6.0.3.893) Hello, Every time I am in a SQL window and use a database link in a select statement, I am asked to commit or rollback even if the query is 100% read only. (the commit and rollback icons become unprotected) ie. select * from table_name@linkname; why is this ...

Thanks Marco ... that was it and all the developers are happy.

It is very consistent but not 100% of the time. SELECT tie_back, edit_dt FROM elogex_log WHERE tie_back = 1 for update; There are no rows returned (intentionally) and then we click the lock icon and the "+" and hi-light the row. It just took me 3 seconds to get into the columns to add data.

Two power-users are reporting to me that 6.0.3 is slower than the previous 5.x version in certain tool functions. Here are two examples that I witnessed: 1. hi-lighting a result set (just a few rows) takes 2 seconds. 2. after an sql query with a FOR UPDATE clause completes, we click the lock...

Hello, I am setting up a new computer with XP Home edition. The Oracle client install (9.2.0.1) was successful. The PL/SQL Developer install was successful. The only file in $ORACLE_HOME/network/admin is tnsnames.ora for local naming. SQLPLUS works fine but I get "TNS: invalid argument"...

The problem with compiling and the udump trace just disapeared ! We can compile again. But I can't rest...what happened? could you give me advice on searching this forum so I can maybe find the thread where this was talked about? Oracle support also asked: Do you have any debugging running...

The following scenario we have done 1000s of times and now the tool is having a problem with a very specific scenario. Oracle 9.2.0.1 solaris 8: This scenario was tried on 5 machines and all with the same results. This just started! 1. we logon to a specific schema (let's call it prod1...

That was so easy!!! Thanks.

Which SELECT v$ tables are needed in the SESSIONS function to view detail in the 1. cursors tab 2. sql text tab 3. statistics tab 4. locks tab? Is this listed anywhere? I know SELECT ANY DICTIONARY works but in some cases I don't want the developer to have so much visuals into the database...

Thank You!

When I type a table name followed by a "." a drop-down box appears with all the columns listed. How do I disable or turn off this feature? Is it somewhere in the preferences? I cannot find it. thanks!

We are running 5.0.1. On my machine the compiler hints appear. On another machine the compile hints do not appear. How do I make the compiler hints window appear on this machine?