Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Embedded PL/SQL Gateway and custom authentication
yossarian wrote:
> Did anyone tried to use custom authentication with Embedded PL/SQL
> Gateway in Oracle XE?
>
> If I set up the "authentication-mode" attribute this way:
>
> DBMS_EPG.set_dad_attribute (
> dad_name => 'my_dad',
> attr_name => 'authentication-mode',
> attr_value => 'PerPackageOwa'
> );
>
> And then I try a simple test package:
>
> create or replace package x as
> function authorize return boolean ;
> procedure hello ;
> end ;
> /
>
> create or replace package body x as
> function authorize return boolean is
> begin
> return true ;
> end ;
> procedure hello is
> begin
> htp.print('hello');
> end ;
> end ;
> /
>
> I get this result from the browser:
>
> Custom Authentication Failure. [x.authorize] oerr = 1006
> ORA-01006: bind variable does not exist
>
> Am I missing something?
>
> Thank you. Kind regards, Yossarian.
Not tested but I believe that you have to set a dummy value for the protection realm in your authorize function as well using owa_sec.set_protection_realm('myRealm') or similar.
-- Niall Litchfield Oracle DBA http://www.orawin.info/servicesReceived on Tue Feb 13 2007 - 00:57:16 CST