Re: Q: How to Pass RecordGroup from Forms to Graphics

Zhou Jian wrote:
>
> hi,
>
> I want to pass a record group to Oracle Graphics. This record group
> is generated by a PL/SQL procedure. The document says that I can
> create a parameter list by
> plid := create_parameter_list(the_param);
> add_parameter(plid, 'chart_data', DATA_PARAMETER, 'chart_record_group');
> and pass the parameter list to Oracle Graphics by
> run_product('chart.ogd', SYNCHRONOUS, BATCH, FILESYSTEM, plid, 'chart_item');
>
> My question is: how can I read the parameters passed from Forms in Graphics?
> How can I get a row or a column from the record group? I have never found
> any functions in Oracle Graphics which allow me to do this. It seems to me that
> Oracle Graphics uses some name conventions to access the parameters passed from Forms.
> Am I right? Can anyone tell me which name conventions are supposed? (query name or
> chart name, etc.)
>
> Any help would be appriciated.
>
> -- Jian Zhou
>
> _________________________________________________________________________
> | | |_|_|_|_| |

 ___|___|_|_|_|_|  Fraunhofer Institute for Computer Graphics             |


> |   |   |_|_|_|_|                                                         |

> |___|___|_|_|_|_|  Jian Zhou            email : zhou_at_igd.fhg.de           |

> |  /--- /   /---|  Wilhelminenstr. 7    phone : (+49) 6151-155-131        |

> | /--  /_  / __ |  D-64283 Darmstadt    fax   : (+49) 6151-155-199        |

> |/    / / /___/ |  Germany                                                |


> |_______|_______|_________________________________________________________|



-- 

Oracle Developer/2000 let's you pass record groups from Forms to Reports or Graphics. The Only way to use the record group in Reports or Graphics, is to give the parameter list the same name as the query for which it should substitute, i.e. if there is a query called "my_query", then when you pass a parameter list (based upon a record group) named "my_query", Oracle Graphics/Reports uses it's columns and rows instead of executing the query.

When should you use it? Well, let's say for example. that your form executes a query which takes quite a long time. If you want to give the user an option to view the results in a graph, then the best way to do so is by creating a record group from the fetched records, and passing it to Graphics. The result will show very fast, because the quecy doesn't have to be re-executed (and there is no need to transfer the records again via the network).

Good Luck
Amir

• Amir M. Farhi *
• Oracle consultant *
• *
• Office: Home: *
• John Bryce (Systems) 1984 Ltd. 4 Yochanan Hagadi St., *
• 35 Jabotinski St., Tel-Aviv 62269 *
• Ramat-Gan 52511 I S R A E L *
• I S R A E L TeleFax: 972-3-5445458 *
• Phone: 972-3-5765660/6 Mobile: 972-52-450424 *
• Fax: 972-3-6131175 e-mail: phantom_at_math.tau.ac.il *
• e-mail: afarhi_at_il.oracle.com (Tel-Aviv University) *

  ---