Re: GETTING USERID ON REPORT

Hi!

You can use function:

function user(par_xxx varchar2) return varchar2 is name varchar2(100);
begin
select user into name from dual;
return name;
end user;

And in report in advanced PL/SQL window ... before displaying the form

htp.p(user('xxx'));

It will print user's name before your report data.

UrRa

jehall_at_my-deja.com wrote:
>
> IS THERE A WAY IN REPORTS TO PRINT THE USERID THAT IS CONNECTED TO THE
> DATABASE ON THE REPORT OR TO SIMPLY RETRIEVE THAT INFORMATION SOMEHOW?
>
> THANKS.
>
> JASON
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Mar 28 2000 - 09:03:21 CEST