Embedded PL/SQL Gateway and custom authentication

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. Received on Mon Feb 12 2007 - 09:01:24 CST