please explain this function [message #306228] |
Thu, 13 March 2008 06:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sharathmpatil
Messages: 38 Registered: February 2008 Location: Bangalore
|
Member |
|
|
function cent(text varchar2,style number,no_button number)
return number is
alert_list varchar2(40) := 'alert_paramlist';
mparam_list paramlist;
malert_no number(1);
mno_button VARCHAR2(1);
begin
mparam_list := get_parameter_list(alert_list);
if id_null(mparam_list) then
mparam_list := create_parameter_lis(alert_list);
if id_null(mparam_list) then
return 0;
end if;
end if;
mno_button := to_char(no_button);
add_parameter(mparam_list,'al_text',text_parameter,initcap(text));
add_parameter(mparam_list,'al_style',text_parameter,
to_char(style));
add_parameter(mparam_list,'no_button',text_parameter,mno_button);
call_form(name_in('global.path') || 'alert',
no_hide,no_replace,no_query_only,alert_list); --calling form alert
destroy_parameter_list(alert_list);
malert_no := name_in('global.malert');
erase('global.malert');
return to_number(malert_no);
end;
function cent(text varchar2,style number,no_button number)
return number is
alert_list varchar2(40) := 'alert_paramlist';
mparam_list paramlist;
malert_no number(1);
mno_button VARCHAR2(1);
begin
mparam_list := get_parameter_list(alert_list);
if id_null(mparam_list) then
mparam_list := create_parameter_list(alert_list);
if id_null(mparam_list) then
return 0;
end if;
end if;
mno_button := to_char(no_button);
add_parameter(mparam_list,'al_text',text_parameter,initcap(text));
add_parameter(mparam_list,'al_style',text_parameter,
to_char(style));
add_parameter(mparam_list,'no_button',text_parameter,mno_button);
call_form(name_in('global.path') || 'alert',
no_hide,no_replace,no_query_only,alert_list);
destroy_parameter_list(alert_list);
malert_no := name_in('global.malert');
erase('global.malert');
return to_number(malert_no);
end;
This is a part of apackage. please explain the function line by line and the functionality of every built in.I m very poor at parameter things. kindly help.
Thanks in advance
|
|
|
Re: please explain this function [message #306239 is a reply to message #306228] |
Thu, 13 March 2008 06:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
This is the second message you post like this and it is hard to read because it is not formatted.
I think you should try to search a bit by yourself, this kind of information is not hard to find. You can use Form builder documentation for most of it or you can try google.
Well this is my 2cp. maybe someone with more time will answer you
|
|
|
|
|
|