Hello All,
I've succeed to call an ON DEMAND process straight through a URL. This works well with an application that uses No Authentication.
Now I'd like to do the same thing, but this time with an application that uses authentication. When I review the basic Application Express Login Page (101) I see that Apex sets up a cookie named : ' LOGIN_USERNAME_COOKIE=admin;'
In my Ajax Request, I'm submitting in the header Cookie= ' LOGIN_USERNAME_COOKIE=admin;'
When I trace this on the EPG side, I see the below. From what I can see, its seems that the headers are never parsed. Is there any way around this problem?
Could I optionaly pass the username ADMIN into my procedure and validate the cookie in there, or will I get the same problem?
Thanks in advance for assitance
Jan
Embedded PL/SQL Gateway: (wppr.c,496) Pl/sql block parsed...
Embedded PL/SQL Gateway: (wpdenv.c,1531) CGI Environment has 30 vars. Max name len 128, Max Value Len 128
Embedded PL/SQL Gateway: PLSQL_GATEWAY(14)=(6)WebDb
Embedded PL/SQL Gateway: GATEWAY_IVERSION(17)=(2)2
Embedded PL/SQL Gateway: SERVER_SOFTWARE(16)=(42)Oracle Embedded PL/SQL Gateway/11.1.0.7.0
Embedded PL/SQL Gateway: GATEWAY_INTERFACE(18)=(8)CGI/1.1
Embedded PL/SQL Gateway: SERVER_PORT(12)=(5)8080
Embedded PL/SQL Gateway: SERVER_NAME(12)=(16)XDB HTTP Server
Embedded PL/SQL Gateway: REQUEST_METHOD(15)=(5)POST
Embedded PL/SQL Gateway: QUERY_STRING(13)=(45)p=107:1:0:APPLICATION_PROCESS=LOOKUP_COUNTRY
Embedded PL/SQL Gateway: PATH_INFO(10)=(3)/f
Embedded PL/SQL Gateway: SCRIPT_NAME(12)=(6)/apex
Embedded PL/SQL Gateway: REMOTE_HOST(12)=(1)
Embedded PL/SQL Gateway: REMOTE_ADDR(12)=(12)11.1.111.11
Embedded PL/SQL Gateway: SERVER_PROTOCOL(16)=(9)HTTP/1.1
Embedded PL/SQL Gateway: REQUEST_PROTOCOL(17)=(5)HTTP
Embedded PL/SQL Gateway: REMOTE_USER(12)=(10)ANONYMOUS
Embedded PL/SQL Gateway: ORACLE_SSO_USER(16)=(1)
Embedded PL/SQL Gateway: HTTP_CONTENT_LENGTH(20)=(2)0
Embedded PL/SQL Gateway: HTTP_CONTENT_TYPE(18)=(1)
Embedded PL/SQL Gateway: HTTP_USER_AGENT(16)=(83)Mozilla/5.0 (Windows; U; en-US) AppleWebKit/531.9 (KHTML, like Gecko) AdobeAIR/2.0
Embedded PL/SQL Gateway: HTTP_HOST(10)=(17)l192.168.1.1:8080
Embedded PL/SQL Gateway: HTTP_ACCEPT(12)=(9)text/xml
Embedded PL/SQL Gateway: HTTP_REFERER(13)=(23)app:/iApplication.html
Embedded PL/SQL Gateway: WEB_AUTHENT_PREFIX(19)=(1)
Embedded PL/SQL Gateway: DAD_NAME(9)=(5)apex
Embedded PL/SQL Gateway: DOC_ACCESS_PATH(16)=(5)docs
Embedded PL/SQL Gateway: DOCUMENT_TABLE(15)=(23)wwv_flow_file_objects$
Embedded PL/SQL Gateway: PATH_ALIAS(11)=(1)
Embedded PL/SQL Gateway: REQUEST_CHARSET(16)=(9)AL32UTF8
Embedded PL/SQL Gateway: REQUEST_IANA_CHARSET(21)=(6)UTF-8
Embedded PL/SQL Gateway: SCRIPT_PREFIX(14)=(1)
Embedded PL/SQL Gateway: (wpd.c,2586) No data returned from procedure
Embedded PL/SQL Gateway: (wpd.c,1960) Begin header parsing...
Embedded PL/SQL Gateway: (wpcs.c, 76) Executed 'begin dbms_session.reset_package; end;' (rc=0)
Embedded PL/SQL Gateway: (wpd.c,1818) Going to close cursor
Embedded PL/SQL Gateway: (wpx.c,660) Normal completion
Embedded PL/SQL Gateway: (wpx.c,688) Shutdown has been called
Embedded PL/SQL Gateway: (wpx.c,700) Going to logoff