السلام عليكم ورحمة الله و بركاته

اولا اعتذر عن عنوان الرساله فى المره الاولى و لكن ماكنتش اعرف القواعد .

ثانيا : ممكن لو سمحتوا حد يشرحلى اجزاء الامر ده , كل جزء يعنى به ايه ؟ يعنى مثلا يقصد ايه ب SYNCHRONOUS
و يقصد ايه بال NULL اللى موجوده فى نهاية الممر ؟

و ياريت لو سرعة الاجابه لانى عندى محاضره بكره و هشرح فيه الجزء ده و هو كيفية ربط الريبورت بالفورم

Run_Product(REPORTS, 'G:\GULF_AIR\report\FLIGHTrdf.rep', SYNCHRONOUS, RUNTIME,
FILESYSTEM, 'NULL');

و شكرااااا

اختي الكريمة اليكي الشرح المفصل

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

وهذا مثال

/* 

** Built-in:  RUN_PRODUCT 
** Example:   Call a Report Builder report, passing the 
**            data in record group 'EMP_RECS' to substitute 
**            for the report's query named 'EMP_QUERY'. 
**            Presumes the Emp_Recs record group already 
**            exists and has the same column/data type 
**            structure as the report's Emp_Query query. 
*/ 
PROCEDURE Run_Emp_Report IS 
 pl_id ParamList; 
BEGIN 
 /* 
 ** Check to see if the 'tmpdata' parameter list exists. 
 */ 
 pl_id := Get_Parameter_List('tmpdata'); 
 /* 
 ** If it does, then delete it before we create it again in 
 ** case it contains parameters that are not useful for our 
 ** purposes here. 
 */ 
 IF NOT Id_Null(pl_id) THEN 
   Destroy_Parameter_List( pl_id ); 
 END IF; 
 /* 
 ** Create the 'tmpdata' parameter list afresh. 
 */ 
 pl_id := Create_Parameter_List('tmpdata'); 
 /* 
 ** Add a data parameter to this parameter list that will 
 ** establish the relationship between the named query 
 ** 'EMP_QUERY' in the report, and the record group named 
 ** 'EMP_RECS' in the form. 
 */ 
 Add_Parameter(pl_id,'EMP_QUERY',DATA_PARAMETER,'EMP_RECS'); 
 /*
 **Pass a Parameter into PARAMFORM so that a parameter dialog will not appear
 **for the parameters being passing in.
 */

 Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
 /* 
 ** Run the report synchronously, passing the parameter list
 */ 
 Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME, 
          FILESYSTEM, pl_id, NULL); 
END; 

شكرا على الرد
بس لو سمحت انا كنت عايزه اعرف ال null
الموجده فى نهايه الكود دى معناها ايه ؟؟ تشير لأيه ؟؟؟
Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);

ارجو التوضيح .

و شكراا

اختي الكريمة
ال null تشير الى display mode وتعني ان يمكن ان ترسلي قيمة باراميتر معين اذا كانت شاشتك تحتوي على graphic
اليكي الشرح

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

اولا شكرا على الرد
بس معلش انا الموضوع مش واضح بالنسبه لى
يعنى لوالفورم تحتوى على رسم معين كيف ارسله للريبورت ؟؟
و رسمه زى ايه مثلا ؟؟

ارجو التوضيح اكثر و ياريت لو مثال

و شكرا

اختي الكريمة
الموضوع ليس كما ذكرتي
مثلا لو كنا عاملين رسمة chart وهذه الرسمة يتم تصميمها عن طريق Graphics Builder chart وهو جزئية من جزئيات الاوراكل حيث يتم تشغيلها عن طريق الريبورت ولكن تعتمد على متغيرات يمكن ارسالها عن طريق ال forms

السلام عليكم
توجد مشكلة فى أمر Run_Product وذلك عند تشغيل الفورم فى ال 10g فما هو الحل؟

السلام عليكم
توجد مشكلة فى أمر Run_Product وذلك عند تشغيل الفورم فى ال 10g فما هو الحل؟

ال run_product لا تعمل مع ال oracle 10 g