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