| Parameters & single quotes [message #393549] |
Mon, 23 March 2009 05:40  |
bartleby
Messages: 2
Registered: March 2009
|
Junior Member |
|
|
Hello,
We are currently using Oracle iAS 10g Forms & Reports Services. We try to execute .rdf using rwservlet, but when we pass user parameters with single quotes, we get "REP-300: invalid number".
For example:
http://<server_name>:<port_number>/reports/rwservlet?destype=cache&P_LIST1="('0619','0001')"&P_LIST2="('001')"&P_LIST3= "('0101')"...
It returns:
REP-300: invalid number
SELECT distinct KFCATENO . ESCE_CO_CODESC , KFCATENO . SOCI_CO_CODSOC , KFCATENO . COGE_CO_COGRAL FROM KFCATENO , KFSOCITO B WHERE ESCE_CO_CODESC IN 0101 AND KFCATENO.SOCI_CO_CODSOC IN 0619 AND ==> COGE_CO_COGRAL IN 001 AND KFCATENO . SOCI_CO
We try to use PARAMFORM=YES, but we have the same problems. URL encoding not work.
Anybody knows how to fix this issue without modified reports?
Thanks in advance.
|
|
|
|
|
|
|
|
| Re: Parameters & single quotes [message #393576 is a reply to message #393562] |
Mon, 23 March 2009 07:39  |
bartleby
Messages: 2
Registered: March 2009
|
Junior Member |
|
|
Yes, it's wrong. I have found something in my tests but I don't understand yet.
If I encode those characters and I add %20% (space code) at the end of each parameter, the report works fine:
http://<server_name>:<port_number>/reports/rwservlet?report=KFIE07R1.rdf&desformat=pdf&destype=cache&P_LIST1=%28%270001%27%2C%270619%27%29%20&P_LIST2=%28%27001%27%2C%27002%27%29%20&P_LIST3%28%270101%27%29%20&P_...
But if I delete the %20%, I get the error. Anybody could tell me why?
Thank you.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
