Recent content by MartinSchm

  1. MartinSchm

    Bug with Comments

    Hi, I found the following bug: If I use the Button of the Developer to put /* */ around some code and later do the same or include the first /* */ into some others, the first /* */ are changed to \* *\ which makes them useless if I delete the outer /* */ bye Martin
  2. MartinSchm

    Add debug information ??

    Hi, if I right-click on a trigger showed in the browser the context menu offers 'add debug information'. On one of my triggers this was enabled, signalised by a little tick. If I click this point, which should disable it in my understanding I get the message "Debug information added" and the...
  3. MartinSchm

    Auto Refresh Query with Parameter

    Hello, if I execute a query like: Select * from Tabelle where Feld = '&Parameter' I get a prompt asking me to enter "Parameter". Everthing fine so far. If I auto refresh the query the prompt pops up everytime the query is executed. Is it possible to enter the prompt just one time ? bye Martin
  4. MartinSchm

    Wrong Compiler Hints

    Hi, don't know if it is a Oracle or PL/SQL Developer error. If I compile a package I get these compiler hints. But some of them are completely wrong. They all are from this kind. - Hint: Parameter 'p_zeitraum' is declared but never used in 'AbgrenzungAufloesen' or - Hint: Value assigned to...
  5. MartinSchm

    Browser & Privileges

    No. But after I enabled the option it worked. Thanks. Martin
  6. MartinSchm

    Browser & Privileges

    Hi, If got a similar problem. I can see the package of a other user in my object browser, but if I select "View Spec & Body" just the spec is opened. My user has EXECUTE and DEBUG privileges on this package and furthermore SELECT privileges on ANY DICTIONARY and ANY TABLE and of course CREATE...
  7. MartinSchm

    How to pass 2 sql statement at same time..

    What you you expect as result of this both queries ? Two different result panes ? Why don't you use a second window for the second query ?
  8. MartinSchm

    Debuger hangs

    Hi it's me again. Another day, the same problem. This morning no debugging on the productive system was possible and I made no changes (!) to the package since yesterday. Just to be sure that it is a Oracle problem which I was convinced of, I installed another program which is able to debug...
  9. MartinSchm

    Debuger hangs

    So, I spoke to my admin and the shared pool size was different. 64 MB on the test and 48 MB on the productive system. Instead of changing the produvtive system we changed the test system to see if the same error would occur. But it is still possible to debug there. BUT, the most mysterious...
  10. MartinSchm

    Debuger hangs

    The first visible difference is that the version number of the test system (the one where I ca ndebug is 9.2.0.4.0) and that of the productive system is just 9.2.0.2.0. I don't know if there are some other differences but there shouldn't be some, because it would make it complicated to run...
  11. MartinSchm

    Debuger hangs

    Hi, I am having the same problem since this morning. Package has around 1400 lines in the body and 230 lines in the spec. Debugging went well for the last three weeks but now stops at the breakpoint and doesn't continue. This doesn't happen if the breakpoint is within the package spec or if I...
Back
Top