Recent content by markis

The script runs fine when in SQLPLUS. However, when running the script in PL/SQL Developer it fails to handle CR/LF. Why would the order have anything to do with the output?

DB: Oracle 9.2.0.6 Listed below is the sql statement in question. When running this sql statement in SQLPLUS on *nux the output, as expected, is displayed on three lines. However, when running this sql statement in the ps/sql developer command window only the first line is displayed. I've also...

Excuse me for my ignorance but where would you look to edit TOracleSession.Preferences.ConvertCRLF?

Server OS: Solaris DB: 9.2.0.4 Client OS: XP Pro PL/SQL Developer: 6.0.3.893 I have a variable defined as varchar2(4000) in a packaged procedure. When the variable is populated near capacity the popup collection view displays =(Long Value). Is there a size limit on viewing a collection...

After deleting the line under DSA and restarting PL/SQL Developer the runtime error window now displayed. Thanks for your help on this issue. :cool: Hopefully this issue of toggling the runtime error window on and off will be included in the preference window in future releases. The need to...

Thanks for the reply. The only setting under DSA is ViewStackDump=7. I'm surprised that there isn't a setting in the preferences window to toggle the runtime error window on or off. Though it is a good thing that the ini files are not binary, I find it odd that an end user would ever have to...

While debugging a procedure we were purposely raising exceptions. This would bring up the run time error window. In this window is a check box asking if you want to continue seeing the window runtime error window. We checked the box so it wouldn't popup the runtime error window. How do we turn...