Recent content by BRi-17

  1. B

    Unable to Change Mode of Self parameter using P/L SQL Developer

    Hello Marco, we have a similar issue by using Pldev version 15.0.3.2058 (64 bit). We have package functions with overloading as follows: CREATE PACKAGE BODY ... FUNCTION fnc_get_tab_comp_desc(p_dckt pkg_pfp_api.TY_PFP_VTABLES) RETURN VARCHAR2 IS BEGIN RETURN...
  2. B

    'SET SQLPROMPT' command window

    After Upgrading to PLD 11.0.5.1775 the feature isn't working any more. My "login.sql" in the PLD folder: set prompt [connection] Prompt in the command window: SQL> When I type in in the command window console "set prompt [connection]" the prompt is renamed to the connection name, but not when...
  3. B

    Toolbar settings are lost after adding a monitor or change resolution

    I defined a personal toolbar. After upgrade to PLD 11.0.3.1770 this toolbar is disappeared. It is not listed in the toolbar definition dialog, only the default toolbars. The other preferences are Ok. How can I get my personal toolbar back?
  4. B

    Reports with a fixed connection overrule connection in other windows

    I installed new version 10.0.1.1694 with all these new connection features...but this bug is still not fixed. When is it planned? Regards, Berit
  5. B

    Wrong scripts by "Export User Objects"

    After changing the file extension for the body files I get 2 different scripts for spec and body. It would be good if a warning would appear before exporting with option "File per object" in case of same definition of the file extension.
  6. B

    Wrong scripts by "Export User Objects"

    I have defined for all program files the extension "sql".
  7. B

    Wrong scripts by "Export User Objects"

    Hello, the export feature doesn't work correctly (Tools >> Export User Objects...). I use version 9.0.6.1665. If I select option "File per object" the body without(!) spec is only created for a package and the master script has 2 commands for spec and body with the same (body) file name. If I...
  8. B

    Open window in full screen mode

    Thank you for the help!
  9. B

    Open window in full screen mode

    Hello, how can I open the windows (sql, command, program...) in full screen mode? After opening the window I always have to switch the mode by the maximise icon. Kind Regards Berit.
  10. B

    Reports with a fixed connection overrule connection in other windows

    I have to correct my post: the bug is also in release 9.0.6.1665.
  11. B

    Reports with a fixed connection overrule connection in other windows

    In previous releases I had the same problem as mentioned above. Now I have updated to 9.0.6.1665 and the problem has changed. The checkbox "Use this connection" in the options tab of the report window is ignored. The report runs always with the current main connection of the developer and not...
  12. B

    List of tablespaces with too many entries

    Hello, if I create a new table or a new index by the editor window and want to assign a tablespace the list has too many entries. My user has just quota on 2 tablespaces and in the list are all tablespaces which exist in the database. The preference "Use DBA Views if available" is active...
  13. B

    multiple instances - connect info

    Thank you for this advice! When I open a new command window or change the connection by typing in "connect user/pw@db" the current user and database is displayed, but when I change the connection by the new connection list at the status bar and execute a statement, the prompt is NOT changed to...
  14. B

    multiple instances - connect info

    Hello, would it be possible to set the corresponding SQLPROMPT in the Command Window, e.g. "user@database> " instead of "SQL> "? In SQL*Plus you can set it in the ORACLE_HOME\sqlplus\admin\glogin.sql by adding command: set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> ". Regards Berit.
  15. B

    RENAME instead of DROP/CREATE constraints

    Hello, if you are in the edit table mode and change the name of a primary key or unique key in tab "keys", the developer creates 2 sql commands for drop and recreate the key. The drop is executing as CASCADE!! Thereby you implicitly drop all referencing foreign keys by one click without any...
Back
Top