Recent content by Maxim4711

  1. M

    EAccessViolation on OraClient12.Dll

    My impression was always - you'll need 32 bit oracle client for 32 bit plsqldeveloper version and 64bit oracle client for 64 bit plsqldeveloper version, isn't it so? Regards Maxim
  2. M

    possible regression - slow performance showing view content

    Hi, Marco, sorry - probably i was unclear. We observe following behaviour with plsql developer: If user supplies any query (regardless - based on views, tables, or whatever) - for user supplied version we see 3 OCI Calls in a sequence: OCIStmtPrepare OCIStmtExecute OCIStmtFetch2 Immediately...
  3. M

    possible regression - slow performance showing view content

    Marco, i need to reiterate on this topic. I have attached a Frida script to plsql developer instance and traced the execution. What i see in the trace - for each of my authorized query plsql developer executes "unauthorized" version. It means, i have following sequence of steps: [OCIStmtPrepare]...
  4. M

    possible regression - slow performance showing view content

    Thanks for fast reply. Your suggested setting for view ddl - changes (in our setup) load of the (problematic) view content to happen instantly, again - thanks a lot! Regards Maxim
  5. M

    possible regression - slow performance showing view content

    I think, i have an issue with possible bug - if i select fully qualified view name in the sql window (maybe either a view name in own schema) - and click on the menu point - view "...my view..." -> view - then by some views it loads extremely long time the content of view into sql window. I...
  6. M

    Accessing objects from another schema

    Why do you think the current behaviour is incorrect? If i understood it properly - it is perfectly aligned with the visibility rules - if you as userA run the query "select id from test_table" - you'll either get error, because the table is in another schema? For that reason, you can't right...
  7. M

    How to show all results in result set besides spamming Alt + PgDn)

    Regarding your second question - i think the most similar approach would be to put the query 2 (or more if required) times into sql window, run it and then select 2 result set tabs (by Ctrl+LeftClick on the tab) - it brings both tabs in foreground, both result sets can be fetched then separately...
  8. M

    How to show all results in result set besides spamming Alt + PgDn)

    Is Alt+End not working for you to fetch last page? Regards Maxim
  9. M

    Test Window shows old procedure / function Code after recompiling

    Editing the procedure in broader sense might include changes to api (renaming of parameter, complete new parameter and so on). To reflect such changes - the test window should completely be reloaded discarding non present parameters and adding new parameters. As of know - i don't think, such...
  10. M

    PL/SQL Unwrapper

    I just published a prototype for unwrapper addon based on excellent luaplsql plugin by Nodir Temirkhodjaev -https://github.com/Maxim4711/luaplsql_addons There is a short README with description how to build it locally, alternatively - i provided a zip release for 64 bit version. I somebody...
Back
Top