APEX

Hi all.
I am running into a problem with the URL I get back from APEX_UTIL PREPARE_URL. It comes back with the query string url encoded so the app server doesn't know what to do with the request. I get to the page I need but get back no data because my query params are ignored. This is being called in a flash chart query - Anychart 5.

I am calling with the following parameters:
APEX_UTIL PREPARE_URL('url', 'UTF-8', 'SESSION')

Until I explicitly added the charset and SSP level, the checksum was not ever calculated and added.

The resulting URL I get:
http://apexserver.domain.com:1234/pls/apex/f?p=105:2:1234567890123456::::P2_START,P2_END,P2_CAT:01-Jan-2010,04-Sep-2010,SVC%26cs%3D31A2CBF884A6CEB932F0F9EFD9EF638DD&cs=3A41011C3DEEF91B7FFE660701289C9E4

If I change the url manually to read:
http://apexserver.domain.com:1234/pls/apex/f?p=105:2:1234567890123456::::P2_START,P2_END,P2_CAT:01-Jan-2010,04-Sep-2010,SVC&cs=31A2CBF884A6CEB932F0F9EFD9EF638DD&cs=3A41011C3DEEF91B7FFE660701289C9E4

the page renders properly. So I know the checksum is good. I tried, in the query wrapping the APEX_UTIL PREPARE_URL call with a REPLACE(APEX_UTIL PREPARE_URL('url'), '%26cs%3D','&cs=') but that did nothing for me. The URL remained with the url encoded values.

We are running Apex 4.0.1 with an 11g database. Any feedback would be appreciated.

Walter

Edited by: WannaRock on Sep 5, 2010 6:18 AM
---------------------------
- Added how I am calling the url, and with which parameters

Edited by: WannaRock on Sep 5, 2010 6:30 AM
--------------------
Added that we are using this in a flash chart