APEX

Hi there Mavel team et al,

One small problem I would like help with ...

I have a requirement for most of my APEX pages to be public, with just two pages which require HTMLDB authentication. (APEX v.2.2)

I want the login screen to appear only when the user clicks on the link for the secure pages.

So, when logged in as 'nobody', when I click on the link to a page set as 'Page Requires Authentication', I get this error :

ORA-01400: cannot insert NULL into ("FLOWS_020200"."WWV_FLOW_COLLECTIONS$"."USER_ID")
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

ERR-1018 Error clearing step cache

If i click on 'Debug', then 'No debug', I can bypass the error.

Can anyone help me get over this error? I can't find any examples of the same problem.

I am using standard HTMLDB authentication. I know I could avoid this problem if my initial page logged users in, but I would like to avoid this.

Thanks in advance,

Rhodri