APEX

Hi

My problem is as follows :

I've created a PL/SQL Page Process called 'FETCH_COOKIE' with
Process Point : On-Load Before Header
Run Process : Once Per Page

The Source Process is :
DECLARE
myCookie OWA_COOKIE.COOKIE;
BEGIN
myCookie := OWA_COOKIE.GET('TWU_COOKIE_TRAQDEV');

:P1_X := myCookie.vals(1);

EXCEPTION WHEN OTHERS THEN
:P1_X := SQLERRM;
END;

Every time the page is run, I get a ORA-06502: PL/SQL: numeric or value error (in the page text item :P1_X). It does not matter what I do, I always seem to end up with this error. The Javascript API function GetCookie is able to get the cookie, so why can't OWA_COOKIE.

Can someone please shed some light on this for me? What am I doing wrong here?

Kind Regards
Greg