Hi,
Can a display item be saved in the database? I am using oracle 6i forms and here are the fields in my table(SO_LINES):
LINE
PRODUCT
QTY
PRICE
ITEMTOT
I made the ITEMTOT field to be a display item. In the property pallete, I made the calculation mode to Formula(:SO_LINES.QTY *...
I have added the 'paramform=NO' parameter, but still the runtime parameter form exists. I have also defined the 'customer_pass' parameter in the user parameters of Oracle Reports. However, when the RUNTIME Parameter appears the customer pass parameter is blank.
IF ID_NULL(CR_PARAM) THEN...
Thank you lewisp for the response.
I have defined the parameter "customer_pass"
in the report. But, what is happening is
after calling the report from the Oracle Forms
a Runtime Parameter Form displays. It shows
the customer pass parameter and it is null.
I still have to enter a...
Hi,
I am studying Oracle 6i Forms/Reports, how do I
pass a parameter from Oracle forms to Oracle reports ?
This is the syntax I used in the oracle forms, to print the so_totals report.
IF ID_NULL(CR_PARAM) THEN
cr_param := create_parameter_list('CREATEP');
ELSE...
Hi,
I am just starting to learn using the PL/SQL interpreter.
When I try to execute a procedure(PROC_TEST) in the PL/SQL interpreter it does not execute.
This is the syntax I made
PL/SQL> PROC_TEST;
PL/SQL>
(It did not state anything whether there is a problem or not. It just displayed the...
Hi to all,
I am planning to buy Oracle 9i database fundamentals I (1z0-031) by Jason Couchman. Could someone comment on this book? Is the book sufficient for preparation on the 1z0-031 exam?
Thank you very much.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.