4 Sep
2013
4 Sep
'13
12:05 a.m.
Hi all, I'm using FR 2.2.0 with Oracle 11g. Now I'm collecting Accounting records into Oracle DB with sql xlat which call a function in PL/SQL. For example in debug mode it expands like below: "%{sql:select wifi_acct.onlineStart(..., '%{Class[*]}',..) from dual}" "TestCL: v=1234;TestCL2: w=5678" => "TestCL: v=3D123456=3BTestCL2: w=3D5678" Here comes the problem, through xlat content of '%{Class[*]}' in SQL string was turned into something like URL encoded string(but not exactly the same) while executing my PL/SQL function. Anyone knows what encode format it is? Any advice would be appreciated! Okis