fn-bea:execute-sql

[Mike Rodriguez]

Hey Jeff!

How have you been?

For a while I haven't post anything in here. But now it's time for me
to ask for a little help.

As you may imagine, the OSB in our company has been growing really
fast.
And right now we're facing a little problem.

I'm using the bea function "execute-sql" to use a query, just to get
some information from a View in a database.
The main problem it's that I'm trying to filter it with date
comparative.

This is the query
SELECT NOMENCLATURE, GENERICNAME, PROFILE, CONTRACT, AGREETYPE FROM
TARIFARIO WHERE to_date(STARTDATE, 'dd/mm/yyyy') >= to_date(? ,'dd/mm/
yyyy') AND to_date(ENDDATE, 'dd/mm/yyyy') <= to_date( ? ,'dd/mm/yyyy')
AND NOMENCLATURE = ? AND GENERICNAME LIKE ? ORDER BY GENERICNAME

But when I try to use it by the OSB it throws me an error, that says
that a non-numeric character was found where a numeric was expected

This is the description.
BEA-382510: OSB Assign action failed updating variable "respuesta":
com.bea.wli.common.xquery.XQueryException: Error parsing XML: line 3,
column 3: {bea-err}RDBW0004: [ds.DAT]: [SELECT NOMENCLATURE,
GENERICNAME, PROFILE, CONTRACT, AGREETYPE FROM TARIFARIO WHERE to_date
(STARTDATE, 'dd/mm/yyyy') >= to_date(? ,'dd/mm/yyyy') AND to_date
(ENDDATE, 'dd/mm/yyyy') &lt;= to_date( ? ,'dd/mm/yyyy') AND
NOMENCLATURE = ? AND GENERICNAME LIKE ? ORDER BY GENERICNAME]:
[sysdate, sysdate, FIQRO, %BIG%]: Error executing SQL query:
ORA-01858: a non-numeric character was found where a numeric was
expected
"
And well as you can see in the detail, the OSB it's changing my
comparative sign "<" for "&lt;" and that's what the parser isn't
recognizing.

Please it's there a way to force the OSB interpreter that ignore this
sign in this case?

Thanks in advance!
I'm in a little hurry about this service, it would be lovely if I can
fix it by EOD.

I appreciate your help!

Regards,
Mike

[kalyan mohan]

Hi Mike

Did you try passing in params in single quotes as below

'FIQRO', '%BIG%'
because oracle understands strings that way

 

Cheers

--
You received this message because you are subscribed to the Google Groups "Oracle Service Bus" group.
To post to this group, send email to oracle-se...@googlegroups.com.
To unsubscribe from this group, send email to oracle-service-...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/oracle-service-bus?hl=en.