Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: Debugging an Oracle Object Type

    So I have an Oracle Object Type that have the member functions in them that I need to modify and add to.

    The problem is, In TOAD, I can't seem to load them into an editor and debug them to determine if they're working properly.

    With regular procs or packages, I can load them up into an editor and hit the lightning bolt, which loads up a window where I can set parameters and execute.

    Not so with Object Types.

    Am I missing something here?

    thanks

    Doug
    Last edited by drdexter33; 04-24-13 at 18:06.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    you should only use Tools & Types that you actually know how to use.
    sqlplus works OK for me.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Posts
    5
    This is the type of arrogant, unaccommodating response I usually expect from the elite snobs at SO.

    you should only use Tools & Types that you actually know how to use.
    I am almost certain most of the people who contemptuously respond to requests for of help in these forums (enjoying the anonymity that the internet provides) would doubtfully show the same fortitude in person.

    Now that I have that out of the way, An helpful responses would be appreciated

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    With free advice, sometimes you get exactly what you paid for it.

    >This is the type of arrogant, unaccommodating response I usually expect from the elite snobs at SO.

    I am curious. What or where is "SO"?

    If you are ever dissatisfied with the tone, tenor, completeness, correctness, or timeliness of any response,
    please submit your request for a prompt & full refund to /dev/null
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    anacedent has a sharp tongue but is smart as a whip.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •