NiceMan331
asked on
How Display messages from database to oracle form
hi
when i have a trigger in oracel form to execute database procedure
the database procedure having :
dbms_output for step info
or error message when raise trigger failur
or to confirm that proceduer compiled successfully
how i can display those 3 types of messages in oracle form
when i have a trigger in oracel form to execute database procedure
the database procedure having :
dbms_output for step info
or error message when raise trigger failur
or to confirm that proceduer compiled successfully
how i can display those 3 types of messages in oracle form
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here is documentation (registration is free):
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/errors.htm#LNPLS007
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/errors.htm#LNPLS007
ASKER
i didn't find any thing related to forms triggers
it is spoken about procedures and handling errors
it is spoken about procedures and handling errors
All about forms triggers - ON-ERROR and ON-MESSAGE triggers - is in the forms help in your Forms Builder.
ASKER
Can you copy the code for both triggers ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx very much for the expanded explanation , I'll try it on Sunday cause the office closed already , thanx
ASKER
regarding this procedure :
procedure show_dbms_output
i will create it in program unit of the form then i will execute it in the trigger before calling my procedure ? or i will its cods inside the database procedure ?
procedure show_dbms_output
i will create it in program unit of the form then i will execute it in the trigger before calling my procedure ? or i will its cods inside the database procedure ?
ASKER
ok now
regarding : showing dbms_output is ok
when proceduer success , ok
remaining when proceduer fail i will wait till i have some transactions has error to see if it will show error message or not
regarding : showing dbms_output is ok
when proceduer success , ok
remaining when proceduer fail i will wait till i have some transactions has error to see if it will show error message or not
ASKER
YES ALSO OK
i tried one sample of procedure having error , and the error message displayed
thanx
now complete solved , just want to know , what "on_error" will do more here and what may be the code
i tried one sample of procedure having error , and the error message displayed
thanx
now complete solved , just want to know , what "on_error" will do more here and what may be the code
" show_dbms_output"
The 'message' built-in is only available in forms .
"on_error" :
What happened with your test having a procedure error: you get 1 or 2 error-messages ?
If 2 : are the message the same ?
The 'message' built-in is only available in forms .
"on_error" :
What happened with your test having a procedure error: you get 1 or 2 error-messages ?
If 2 : are the message the same ?
ASKER
I got one error message which on when others at the end of my database procedure
ASKER