Oracle is probably the most popular enterprise database server at the moment. This is the server that powers eBay on the web and countless datawarehouses and VLDBs around the world. Oracle is suited for all applications from OLTP to Data Warehousing. The latest 9i even has a built in OLAP engine.
how to display message from package to forms
I have written package in back end.
i am calling teh package from form, i ahev done some complex calculations.
i want to see the intermedite values from form.
how can i do this.
any help will be appreciated
Thanks in advance.
Complex calculations? I'd suggest you to simplify them - break one large function into several simple functions (or procedures; in such a case you'll have to have an OUT parameter).
Then, from the Oracle Form call your functions; you'll need a local variable which will be able to receive function's return value (your "intermediate value", that is). Output this value using MESSAGE or ALERT. Something like:
/* WHEN-BUTTON-PRESSED trigger, for example */
l_retval := pkg_of_yours.function1;
message('1st function value: ' || l_retval);
l_retval := pkg_of_yours.function2;
message('2nd function value: ' || l_retval);
/* and so on */
Thank You very much for your reply.
Ok I apprecite the solution.
In day to days work i too follow the same method, but i have a doubt how to print the package intermediate results to form.
Can't we print the messages from back end packages to form?.
No, the only way the package can communicate with the form is by OUT parameters and return values. The server knows nothing about your form, or even whether you are running a form at all.