Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Embedded PL/SQL Gateway and custom authentication

Re: Embedded PL/SQL Gateway and custom authentication

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 13 Feb 2007 06:57:16 +0000
Message-ID: <zPWdnfB9NJGuw0zYRVnygw@pipex.net>


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/services
Received on Tue Feb 13 2007 - 00:57:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US