Recent content by akaya

  1. A

    How to see time portion of date variable in debugger?

    This works, thank you.
  2. A

    How to see time portion of date variable in debugger?

    Hi, When using debugger, I can only see the date portion of the variable. How can I see time portion of the variable? Thank you. Sample test window: declare v_date date:=sysdate; begin dbms_output.put_line(v_date); end;
  3. A

    Which property can I use to determine if an operation is running on TOracleSession

    Please consider adding a property for future DOA releases. Thank you.
  4. A

    Which property can I use to determine if an operation is running on TOracleSession

    We have a single TOracleSession used by main VCL thread and background threads. I would like to check if a background thread is executing some operation on TOracleSession. I read the manual and cannot see a property for this purpose. Which property can I use to determine if TOracleSession is...
  5. A

    Package wizard does not interface procedure without parameters

    Hi, We have reported this bug to support@allroundautomations.com in 2019. Still no solution.
  6. A

    AfterExecuteWindow - Unexpected value in Result

    I am trying to use Result from AfterExecuteWindow. procedure AfterExecuteWindow(WindowType, Result: Integer); begin ShowMessage('AfterExecute ' + IntToStr(WindowType) + ' ' + IntToStr(Result)); end; According to plugin documentation I should get 0,1 or 2 as Result. However, when I open an...
  7. A

    Close window when pressing mouse middle button on Tab Control (or mouse wheel click)

    In Firefox for example, we can use mouse middle button to close tabs. Now that you have implemented a Tab Control in PL SQL Developer v13, would it be possible to close the window when we bring mouse cursor over a Tab or Window List and press middle mouse button?
  8. A

    Package Wizard bug on Oracle 19c

    Package and generated pas has been sent to support@allroundautomations.com.
  9. A

    Package Wizard bug on Oracle 19c

    When can we expect to hear from you? Thanks.
  10. A

    DBMS_Jobs 'DATE' is not a valid date error

    Hi, I am evaluating plsqldev13 with Oracle 19c database. When I try to right click and View/Edit a job on DBMS_Jobs, I get the following error: '04-NOV-19 05.21.39.161938 PM +03:00' is not a valid date PL/SQL Developer Version 13.0.6.1911 (32 bit) Using Home: OraClient11g_home1 DLL...
  11. A

    Package Wizard bug on Oracle 19c

    Hi, We migrated our development database from 11g to 19c. When we use package manager, procedures with no parameters are omitted from the generated .pas file. Can you check and advise? Thank you. Edit: We noticed procedures with no parameters are missing from all_arguments view. This may be...
  12. A

    What could cause error message Query thread is still in progress

    Checking TOracleQuery.ThreadIsRunning before Execute seems to fix this issue. However, query in question was firing once per minute with execution time of 0.05 seconds. I do not see how it was possible that Thread was still executing.
  13. A

    What could cause error message Query thread is still in progress

    Hello, We recently set TOracleQuery.Threaded = True for executing a query in background thread. Sometimes we get error message "Query thread is still in progress". What could cause this error? TOracleQuery.ThreadSynchronized = True TOracleSession.ThreadSafe = True DOA 4.1.3.5 - Delphi 10.1...
  14. A

    OracleMonitor - Maximum of 100 clients allowed.

    I believe some of the ghost entries belonged to applications that were killed using Task Manager. Unfortunately it is very hard to restart the server. I was wondering if there was any way to remove the entries without restarting. Also, it would be appreciated if you could suggest a...
Back
Top