Recent content by greg.mccarty

  1. greg.mccarty

    Understanding login.sql and afterconnect.sql

    Slava, Thanks for the info. Sorry for the long delay in thanking you. GregM
  2. greg.mccarty

    Understanding login.sql and afterconnect.sql

    Ok, I've got the following lines in my login.sql: vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv set serveroutput on size 1000000 set long 5000 set linesize 100 set pagesize 9999 set termout off variable gname varchar2(100) begin select lower(user) || '@' || global_name into :gname...
  3. greg.mccarty

    Default folder order

    Oops, sorry, badly asked questions. I understand the reordering of the folders themselves. What I'm looking for is reordering the contents of each folder. For instance, when I see the packages within a package folder, I'd like to see the packages in alphabetical order. I notice that when...
  4. greg.mccarty

    Default folder order

    I'm sure I've missed this, but how do I set the order by for the default (i.e. plsql dev defined) folders? In particular, the package bodies. Thanks, GregM
  5. greg.mccarty

    printing font

    I need a little font direction. When I print, the font used is proportional, so nothing lines up. How do I configure the font used for printing? BTW, I've set up my editor font to be fixedsys. Thanks. GregM
  6. greg.mccarty

    Enhancements to the command window

    I'm a relative newbee to Oracle. So, following the lead of some in the know, I buy one of Tom Kytes (asktom) books - Expert Oracle Programming Techniques... In the setting up chapter, it has a great little script for login.sql that configures the session and sets the prompt. Unfortunately, it...
  7. greg.mccarty

    A test script calling another script

    I would like one.tst to call init.tst, execute some stuff, and then call cleanup.tst. Think of it as the standard steps in a test framework. Init, test, cleanup. But I was wondering if a .tst could call other .tst's.
  8. greg.mccarty

    Problems creating procedure as language java in command window

    Did this ever get fixed? I have version 6.0.5.931 I get a slightly different problem. I open a command window, and @ execute my big compile script. When I reference (using @@) a .jsp file, it compiles, but gives me java compilation errors. I do a show errors, and it gives me errors on lines...
  9. greg.mccarty

    A test script calling another script

    BWendling, It's not that I want my test script (call if first.tst) to all a package/procedure. What I want is my test script to call another plsql developer test script (say second.tst). So it's plsql dev artifact calling a plsql artifact.
  10. greg.mccarty

    filters on db links

    I notice that when I set a filter, it doesn't apply to db links. Is this a bug? Or did I not set an option?
  11. greg.mccarty

    ORA-06502 sporatic error

    Ok, never mind. I have to post the question to find the answer. Here was the problem. In my package spec, I did the following c_MyVal CONSTANT varchar2(2) := 'ALL'; This compiled !! However, it was causing the problem. When I change the length to 3, the behavior went away. Strange!
  12. greg.mccarty

    ORA-06502 sporatic error

    Oops. Running against Oracle 9i 9.2.0.5
  13. greg.mccarty

    ORA-06502 sporatic error

    Ok, here's the problem. I've written approx 30 test scripts. Once done (of course), I realized that a lot of the dbms_output dumps were duplicated, so I put them in a package called DEBUG_MGMT. I then changed the scripts to call the appropriate procedure in that package. When I run a script...
  14. greg.mccarty

    A test script calling another script

    The call I want to make is to another test script, not to a package/procedure.
  15. greg.mccarty

    Determining the latest version

    I see the version info on the news page. All I see on the download page is 6.0. Thanks.
Back
Top