Recent content by whip

I think, the easiest is: Right click -> Browse and then open the Triggers folder. Or: create a new menu item with the Browser Extender plugin.

Just for the record: the script is originally my work and a formatted version can also be found at http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=001632 Cheers, whip

Yes, all objects were valid, I checked that. What I thought of is that the "existing state" of a package (held in the PGA?) may get invalid if referenced objects are modified. If I remember correctly, this cached invalid state is not refreshed automatically by the Oracle Server. However, I tried...

I have a very similar problem. When I recompiled a package, my test window started complaining that the program unit was invalidated (As far as I remember PLSQLDev used to recompile referenced packages automatically without complaining before. Now this does not happen, why?) And offered the...

I guess my reply arrived a few minutes late... ;)

After some testing, I found that the trick is how you name (and populate) columns in the referenced table. In my case the table was: create table CT_CATEGORIES ( ID NUMBER(12) not null, NAME VARCHAR2(240) not null, EXT_KEY VARCHAR2(40), DESCRIPTION VARCHAR2(4000) )...

When editing data in a foreign key column of a table then PL/SQL Developer shows a drop down list with data from the referenced table. This list usually contains the PK column and a few descriptive fields. Today I started developing a new application based on new tables and only the PK column...

Starting with the 9i version of the database, CASE is supported in PL/SQL.

Searching for your error message I found: Please verify that this applies to your case before doing something irreversible ;) .

You probably need to set the regional and language options of the default user the same way as your own user in Control Panel.

This is an internal error message, probably related to a bug in the RDBMS. (Some of) the bugs causing this message are fixed in 9.2.0.3 and 10.1.0.2

Just a guess, as the text contains syntactic errors: PLSQL Developer might recognize v$session as an alias to dual (as in select * from dual v$session)

I think in previous versions you could copy and paste columns in the table editor. Now it does not work, this gives 'Unexpected error' Log file contains: ---------------------------2005.01.27. 14:10:45--------------------------- Exception 'EAccessViolation' in module plsqldev.exe at 00576A7D...

You can drag and drop the table name from the browser and click on 'Select' in the menu appearing.

Thanks for the addition. My purpose was just to show our approach with a simplified example. Cheers