Recent content by Joe

The following would add great value when you are seeking dependencies of an object, example: under the View branch, expand an existing view expand the References branch, this lists the objects this item references. The enhancement would see the next level improved as such; expanding the tables...

I am using multi-session mode. when it 'hangs' pl/sql dev stops responding completly and any further mouse clicks on it results in 'Not Responding' shown in the title of pl/sql dev. Are you suggesting then to kill the session through another instance of pl/sql dev?

During execution of the proc in the pack.

I am using PL/SQL Dev ver 6.05.926 The package executes fine on a small set, however, when there are many thousands of records to process, after sometime (random) pl/sql dev hangs. Is this common? What is the solution?

I am using PL/SQL Developer Version 6.0.4.906 (MBCS) Home: OraHome92 DLL: C:\oracle\ora92\bin\oci.dll OCI: version 9.2 Oracle9i Enterprise Edition Release 9.2.0.1.0 I have used the TS and LR variables in other functions and they compile without any warnings, but they are not as deep...

Thanks Marco; I have pasted a the code in question; the lines marked with ---HINT are the places where the hint warnings are raised. Do not compile this as it will not work as some external methods are called. For brevity I have removed all the excess irrelevant code and supplied an outline of...

After compiling the package in PL/SQL Dev the returned hint is as follows: Compilation errors for PACKAGE BODY TEST.PKG Error: Hint: Value assigned to 'TS' never used in 'PROCESS_MODE' Line: 212 Text: TS := 'COMPLETED'; The depth of the above assignment statement is 5, i.e. it resides with in...