Calling Portal wwsec_api from Apex

From: <danny.roach_at_oracle.com>
Date: 29 Nov 2006 07:26:30 -0800
Message-ID: <1164813990.826520.264390_at_h54g2000cwb.googlegroups.com>

[Quoted] I am trying to call the portal.wwsec_api from within an apex application. The application is parsed using the portal schema so has all the correct grants by default.

The code I am using is:

declare
l_person_rec wwsec_person%rowtype;
begin
l_person_rec := wwsec_api.person_info
(
p_user_name => 'PORTAL'
);

:P3_USER_INFO:=l_person_rec.user_name || l_person_rec.first_name;
exception
when others then
:p3_user_info:=sqlerrm;

end;

This code (minus the item references) runs fine in sqlplus, but errors when I run it in apex. I have narrowed it down to the api that is erroring as I can access the table direct.

Can anyone help with this?
Thanks Received on Wed Nov 29 2006 - 16:26:30 CET