I am seeing behavior where the debugger commands seem to be ignored also. When I am running a test of a function or procedure in a package, and I attempt to run it in the debugger, the "step into" button acts like the run button and executes the entire function or procedure. This has happened...
Thanks, Marco.
I will see if I can get by with using the file listed above for now. I don't think it will impact me to apply the same settings to all connections.
I am running PL/SQL Developer version 10.0.5.1710. Is there any way to specify optional connection parameters for the Oracle connection I am making for the session?
We have some tuning parameters within the connection itself that we would like to assign. I can make these in other IDEs, such...
Getting the same thing here on WinXP Pro, using the version listed above. Selecting the minimize icon in the top corner of individual oracle SQL windows works etc, but trying to minimize the entire PL/SQL Dev application window does nothing except causes it to lose focus.
Thanks for the info Jason. I did some preliminary searching before posting but somehow missed the post. I am not sure how, now that I look at how logical your title was, but all I can do is apologize.
I added just this package to be handled in this way, as Marco mentioned in the other post...
I have a package that I have built and maintained for a few years now in PL/SQL Dev. For some reason, when I compile the package in an oracle 9.2.0.4 instance, it compiles fine. When I compile the same exact package into my 9.2.0.6 instance on a seperate server, it gives me the following...
For some reason, this issue went away when we reformatted the server and reloaded oracle and patched it to 9.2.0.4. We also recreated another user in the db that builds objects based on MDSYS, so that could have been part of the problem as well.
A simple test table would be:
CREATE TABLE...
Hi Marco,
I am sending an email reply with this now. I am also able to reproduce the issue at our client site, with their configuration being roughly the same. I can try it in our office as well later in the week.
Thanks,
Aggieangler
One thing I omitted. This occurrs when the database is trying to select * from the table. I have seen similiar behavior in other apps when trying to connect to tables with MDSYS.SDO_GEOM objects. It could be the same issue. Tables in the same DB that don't have a geometry data type column in...
We have recently noticed an issue with PL/SQL developer when connected to Oracle 9.2.0.4. When we edit a table that has a column in it of type MDSYS.SDO_GEOMETRY, we get an error. The error is "ORA-03113 End of file on communication channel". Then we get an error indicating that the connection...