DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

Hybrid View

  1. #1
    Join Date
    May 2007
    Posts
    2

    FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

    I convert form 6.0 to form 10g and when run the form and this try to connect to other server, the following mensage appears:"FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508".

    I debug the form and found supposedly the problem:
    connection_id :=
    EXEC_SQL.OPEN_CONNECTION('scott/tiger@odbc:batabase')

    my question is: This command of being written different in oracle 10g?.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    typo, batabase instead of database?

  3. #3
    Join Date
    May 2007
    Posts
    2

    FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

    Thank, but "batabase" is a example of the real name of database.

    EXEC_SQL.OPEN_CONNECTION('scott/tiger@odbc:batabase') "batabase is a example"

  4. #4
    Join Date
    Feb 2005
    Posts
    158
    Yipes.
    EXEC_SQL is the parallel to DBMS_SQL in the database.
    It is trying to open a database connection.
    Forms 6.0 was client/server, so it was up to the local PC to resolve the connection string.
    Forms 10g is web-based, so in Production this will be up to the application server machine.
    If you are just testing the form locally, you may be using that local 'pretend' app server, in which case it will be the local PC trying to resolve the connection string.

    The design question is what is this 'batabase' database about, where does it sit, and how will the application talk to it

Posting Permissions

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


Click Here to Expand Forum to Full Width