Link to home
Start Free TrialLog in
Avatar of NiceMan331
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
SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NiceMan331
NiceMan331

ASKER

can you set the codes here ? or even the link of the documentation plz
i didn't find any thing related to forms triggers
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.
Can you copy the code for both triggers ?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanx very much for the expanded explanation , I'll try it on Sunday cause the office closed already , thanx
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 ?
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
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
" 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 ?
I got one error message which on when others at the end of my database procedure