static or report wide variables?

[jparrott]

I have a format trigger that looks like this:

function R_G_sample_idFormatTrigger return boolean is
begin
  if (owa_pattern.match(:sample_id, '^\D'))
  then
    srw.set_foreground_border_color('black');
    srw.set_border_pattern('solid');
  else
  	srw.set_foreground_border_color('white');
  end if;

  return (TRUE);
end;

I need to add to the if condition something that says "if I've already do this, don't do it again", so something like this:

function R_G_sample_idFormatTrigger return boolean is
begin
  if (owa_pattern.match(:sample_id, '^\D') and flag = 0)
  then
    srw.set_foreground_border_color('black');
    srw.set_border_pattern('solid');
    flag := 1;
  else
  	srw.set_foreground_border_color('white');
  end if;

  return (TRUE);
end;

The easiest way I can think to do this would be with a static variable, but I haven't been able to find any documentation on static variables in PL/SQL. Another way would I thought to do this would be to create a report wide variable that would act the same way.

Thanks,
Justin

 

[sem]

You may use parameter or package variable.

Regards, Dima

 

[jparrott]

Thanks for your response. How do I create a package variable in Reports?
Justin

 

[sem]

Just add some package spec to Program Units and declare some variable in it.

Regards, Dima