Recent content by LMW

yes, in Version 8 it is working as a workaround add space before SELECT keyword and it will work for r_rec in ( select t.column from TABLE t) loop

Hello, If you create a test window from a procedure name in a context menu (browser/code contents/program window ,..), it will contain only contain the call to the procedure with its parameters. Is there a template to fill this script with standard code, as it can be done, if you create a test...

Hello, this happens also in Version 6.0.6. It seems, that also the exception NO_DATA_FOUND is captured by the SQL-Window and COMMAND-Window functionality.

Hello, maybe system privilege DEBUG CONNECT SESSION is missing which is mandatory when using oracle 10g. LMW

Hello, maybe in PSD you have set up to compile with debug information. the additional info may exceed the size limit. regards LMW

Hello Remo, the comments will be stripped by Oracle not by PSD. But you will not lose your comments in views, if you place them behind the "select" - Keyword e.g. --Comment that will be stripped CREATE OR REPLACE VIEW TEST --Comment that will be stripped AS --Comment that will be stripped...

Hello, I checked and I see BE is working on Windows XP SP2 for all Oracle Versions, but not working on WIN2000 SP4 for Oracle10g Maybe it'll help you. Regards LMW

Hello, it looks like BE Version 2.0 doesn't work in Oracle 10g at all. Maybe it is disabled for this version. Must I use BE Version 2.5 now? Regards LMW

For example I use a command for tables,views to show the number rows: The caption shows (on right click on table/view): "Table,View contains #field_0 row(s)", so #field_0 is not resolved. Moreover the command is not enabled (grayed). The same situation I have with other BE-Commands. In an...

Hello, it's a great plugin using browser extender to extend functionality for own needs. In 10g there is a problem resolving the "#"-Variables for caption and actions. Regards LMW ###### using plsql/dev 6.0.5.931 and browser extender 2.0

Hello, indexes and constraints don't seem to be on the list of recognized types, nor do some newer object types like OPERATOR, TABLE PARTITION do. Can they be added to this list. Regards LMW

Hello, maybe, you have set registry entry in HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\PlugIns\plsqldoc from earlier installation for a directory pointing to another directory than new version expects it. Change registry entry to new directory or delete it. Hope it helps...

Hello, I am using PLSD 6.0.5. The context menuitem "add debug information" is not working. I am only able to compile with debug, if I switch "add debug information when compiling" in the preferences. This seems to be a bug in 6.0.5., I haven't noticed that in previous versions. LMW

Hello, if there is fractional part (time) in the date field , you have to select with trunc(table_datefield) = '31.12.2004' The preference-setting is for formatting the output not for querying. regards Wilhelm

Hello, the best you can do here, is to use different PLSD shortcuts and use the commandline parameters oraclehome (and userid) for connecting to different databases with different oracle-homes. Regards Wilhelm Lamers