Recent content by rabrabbie

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 *...

Thanks Dima. It's now working!!!

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, Which trigger fire first, On-populate-details or On-clear-details for the Master - Detail relationship? Thanks.

It is an exam guide. I found the book's title "Oracle 9i database fundamentals I" at amazon.com.

Hi everybody, Does the POST-QUERY trigger fire before or after the records are shown to the user? Thanks.

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.