| Re : recordgroup [message #86921] |
Sat, 20 November 2004 00:14  |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
-
hi guru
I know this syntax but i am presently using the text parameter but now i want to know how to define & use the data parameters.
ADD_PARAMETER examples
/*
** Built-in: ADD_PARAMETER
** Example: Add a value parameter to an existing Parameter
** List 'TEMPDATA', then add a data parameter to
** the list to associate named query 'DEPT_QUERY'
** with record group 'DEPT_RECORDGROUP'.
*/
DECLARE
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tempdata');
IF NOT Id_Null(pl_id) THEN
Add_Parameter(pl_id,'number_of_copies',TEXT_PARAMETER,'19');
Add_Parameter(pl_id, 'dept_query', DATA_PARAMETER,
'dept_recordgroup');
END IF;
END;
my questios is this where & how do i define/put the dept_query,dept_recordgroup etc.
regards
jhs
-
|
|
|
|
| Re: Re : recordgroup [message #86927 is a reply to message #86921] |
Sun, 21 November 2004 19:39  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Use following Syntax:
DECLARE
pl_id ParamList;
rg_id RecordGroup;
rg_name VARCHAR2(100) := 'dept_recordgroup';
errcode NUMBER;
BEGIN
pl_id := Get_Parameter_List('tempdata');
IF NOT Id_Null(pl_id) THEN
Add_Parameter(pl_id,'number_of_copies',TEXT_PARAMETER,'19');
rg_id := Find_Group( rg_name );
IF NOT Id_Null(rg_id) THEN
Delete_Group( rg_id );
END IF;
errcode := Populate_Group(rg_id );
rg_id := Create_Group_From_Query(rg_name, 'Put your query here or assign thte Query string variable');
Add_Parameter(pl_id, 'dept_query', DATA_PARAMETER,
'dept_recordgroup');
END IF;
END;
Ensure that name of the Query Groupn in your Data model is dept_query.
HTH
Regards
Himanshu
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
