Recent content by agent86

Marco. Thanks a lot.

But it doesn't work like that. That is what I am saying. I can put my cursor in the package body tab, put my cursor right at the to-do line and click Edit --> To-do Items --> Show List... and nothing shows. So my test is: 1. right click the package from the browser and choose "View Spec &...

I have some more information. If I explicitly work on the portion of the package that has the to-do item, I can get it to show. I don't get this behavior in version 7.1.5. Let me explain. The package code I am using is at the bottom. If I: 1. right click the package from the browser and...

Hi Marco, Same behavior. As soon as i added a new TO-DO item and click "Show Items..." I see them all but if I close the package and reopen I lose them all in the Show List Window. Any thing else you need me to try?

Hi, Version 8.0.2.1505 It appears that the T0-DO item "Show List" is buggy. Steps: open package and add TO-DO item. Click Edit --> TO-DO Items --> Show List... The item shows up. Now close the package and reopen (either from file or right click) Click Edit --> TO-DO Items --> Show List...

Hi, It does not appear the commandfile option will allow you to pass parameters to a script. For example: plsqldev userid=scott/tiger commandfile=d:\tmp\test.sql scott if d:\tmp\test.sql was select * from all_users where username = upper('&1'); Once PL/SQL Developer Starts it always prompts...

That's a classic ad! My thoughts: "I'll have time to create a fire with sticks" "I'll have time to fight cursed demons in the woods" "I'll have time to join a tribe and learn their customs" "I'll have so much free time that I can actually do any bizare activity and not feel like i'm wasting...

Hi, Can you make it so when a schema diff drops a column that has a FK on it, the compare tool does not add the drop FK constraint to the output? The foreign key does not exists after the column drop and the next statement always fails. It can be ignored but I cant think of a reason why it...

This syntax works in packages with a 9i home with Version 7.0.1.1066. In versions 7.0.2 and 7.0.3 it starts acting funky and even removes the procedure names from the contents window when viewing package body section. Note this package. No procedure list shows in the package body until your...

Any way to prevent showing deleted files when checking out files? Perforce has an option to show or hide deleted files. No big deal but would be nice not to see a clutter of red triangles ;) thanks Also if you create a materialized view, then right click on the MV from the "tables" section...

Also compare data does not work when using timestamp with local time zone datatype. It returns an error saying column is not a date. Can this get fixed please? thanks

Can we please get plsqldoc to cross link without having to have database and owner checked under "Object name prefix" under configuration? Currently BOTH need to be checked in order to have links in the documenation. It would be nice to have any combination work. Also is there a way to supress...

email sent. thanks Marco

Pretty easy to recreate: CREATE TABLE exp_clob_test (ID INT, c_data CLOB DEFAULT empty_clob() ); INSERT INTO exp_clob_test VALUES (1, 'test'); COMMIT; They try to export using the PL/SQL Developers tab. I get a small error box that says "write stream error". Perhaps its my environment but not...

Tools --> Export Tables --> Pl/SQL Developer Tab I could have sworn it worked before. I have tried it on both CORE 9.2.0.6.0 and 9.2.0.7.0 versions. Not sure what else to check.