Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Modify URL in pl sql web toolkit
Modify URL in pl sql web toolkit [message #521740] Thu, 01 September 2011 11:26 Go to next message
sumitmahajan12
Messages: 4
Registered: April 2008
Junior Member
Hi
I have a simple form and it passes 1 parameter to the URL

www.xxx.com?p_param=123

Instead of passing 123, because user can change URL to 345.
can i somehow scramble the displayed parameter value or not display it at all?

and after passing parameter, I use it to retrieve more data.

thanks !

Re: Modify URL in pl sql web toolkit [message #522122 is a reply to message #521740] Tue, 06 September 2011 13:28 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
if you change your form from QUERY to POST, then you wont have URL parameters. You can also use something like this to obfuscate values to a certain extent.

SQL> select UTL_RAW.cast_to_raw('21/03/2010 10:20:43') from dual

UTL_RAW.CAST_TO_RAW('21/03/201010:20:43')
--------------------------------------------------------------------------------
 32312F30332F323031302031303A32303A3433 
1 row selected.

SQL> select UTL_RAW.cast_to_varchar2('32312F30332F323031302031303A32303A3433') from dual

UTL_RAW.CAST_TO_VARCHAR2('32312F30332F323031302031303A32303A3433')
--------------------------------------------------------------------------------
 21/03/2010 10:20:43 
1 row selected.
Previous Topic: upload/import works only if last column contains NON NULL values
Next Topic: PDF garbage display
Goto Forum:
  


Current Time: Mon Aug 03 13:15:40 CDT 2020