-
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?.
-
typo, batabase instead of database?
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|