Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: Forms (bad) behavior

    Setup: Developing Forms 9i on 9i (vanilla) release 2, using OC4J to support web forms

    When working with my app I am getting an error from my trigger (the error is not important). When I go to the Help menu and press "Display error" Oracle reports "FRM-42100: No errors encountered recently". When I was a younger man ("hand me my cane Brenda") I recall that you could display the actual SQL that was in error. I expected the Help->Display error to do the same. Is this something that has changed or am I recalling it wrong.

  2. #2
    Join Date
    Dec 2003
    Posts
    74
    it depends on what level the error occured.

    Try displaying the error via a message box using

    SQLCODE SQLERRM

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    That would just give me the AAA-#### and description. I am looking for the actual failed insert or what ever.

    As further clarification I should say that I at least would expect the Help->Display Error path to show me the AAA-#### it just showed me (reported)

Posting Permissions

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