Answer Posted / priyanka
We can use RUN_PRODUCT function for doing so.....
Description
Invokes one of the supported Oracle tools products and
specifies the name of the module or module to be run. If
the called product is unavailable at the time of the call,
Form Builder returns a message to the end user.
If you create a parameter list and then reference it in the
call to RUN_PRODUCT, the form can pass text and data
parameters to the called product that represent values for
command line parameters, bind or lexical references, and
named queries. Parameters of type DATA_PARAMETER are
pointers to record groups in Form Builder. You can pass
DATA_PARAMETERs to Report Builder and Graphics Builder, but
not to Form Builder.
To run a report from within a form, you can alternatively
use the dedicated report integration built-in
RUN_REPORT_OBJECT .
Syntax
PROCEDURE RUN_PRODUCT
(product NUMBER,
module VARCHAR2,
commmode NUMBER,
execmode NUMBER,
location NUMBER,
paramlist_id VARCHAR2,
display VARCHAR2);
PROCEDURE RUN_PRODUCT
(product NUMBER,
module VARCHAR2,
commmode NUMBER,
execmode NUMBER,
location NUMBER,
paramlist_name VARCHAR2,
display VARCHAR2);
Built-in Type unrestricted procedure
Enter Query Mode yes
Parameters
product Specifies a numeric constant for the Oracle product
you want to invoke: FORMS specifies a Runform session.
GRAPHICS specifies Graphics Builder. REPORTS specifies
Report Builder. BOOK specifies Oracle Book.
module Specifies the VARCHAR2 name of the module or module
to be executed by the called product. Valid values are the
name of a form module, report, Graphics Builder display, or
Oracle Book module. The application looks for the module or
module in the default paths defined for the called product.
commmode Specifies the communication mode to be used when
running the called product. Valid numeric constants for
this parameter are SYNCHRONOUS and ASYNCHRONOUS.
SYNCHRONOUS specifies that control returns to Form Builder
only after the called product has been exited. The end user
cannot work in the form while the called product is running.
ASYNCHRONOUS specifies that control returns to the calling
application immediately, even if the called application has
not completed its display.
execmode Specifies the execution mode to be used when
running the called product. Valid numeric constants for
this parameter are BATCH and RUNTIME. When you run Report
Builder and Graphics Builder, execmode can be either BATCH
or RUNTIME. When you run Form Builder, always set execmode
to RUNTIME.
location Specifies the location of the module or module you
want the called product to execute, either the file system
or the database. Valid constants for this property are
FILESYSTEM and DB.
Paramlist_name or paramlist_ID Specifies the parameter list
to be passed to the called product. Valid values for this
parameter are the VARCHAR2 name of the parameter list, the
ID of the parameter list, or a null string (''). To specify
a parameter list ID, use a variable of type PARAMLIST.
You can pass text parameters to called products in both
SYNCHRONOUS and ASYNCHRONOUS mode. However, parameter lists
that contain parameters of type DATA_PARAMETER (pointers to
record groups) can only be passed to Report Builder and
Graphics Builder in SYNCHRONOUS mode. (SYNCHRONOUS mode is
required when invoking Graphics Builder to return an
Graphics Builder display that will be displayed in a form
chart item.)
Note: You can prevent Graphics Builder from logging on by
passing a parameter list that includes a parameter with key
set to LOGON and value set to NO.
Note: You cannot pass a DATA_PARAMETER to a child query in
Report Builder. Data passing is supported only for master
queries.
display Specifies the VARCHAR2 name of the Form Builder
chart item that will contain the display (such as a pie
chart, bar chart, or graph) generated by Graphics Builder.
The name of the chart item must be specified in the format
block_name.item_name. (This parameter is only required when
you are using an Graphics Builder chart item in a form.)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What do you understand by lov?
how to send file attachment from oracle forms
a text item is there what r the different types of triggers associated with it
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
if u want to delete all these detail block etc what will happen in form
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
what are bind variables?
What is an SQL FORMS ?
Is it possible to execute a dynamic sql from forms?
where do u put the report file
can you convert or reverse engineer a fmx back to a fmb file?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Explain master-detail relationship with some examples.
