OracleOleDB problem?

[lubos]

Hello,
I begin to play with oracle and EA.
I connect to DB using Oracle Provider for OLE DB.
I have the following problem:
this SQL query>
select instr('Tag:Value',':') + 1 AS C1 from dual;

returns 5 in PL/SQL Developer
but
returns 41 when using it as as Custom SQL search in EA.

Is this a problem of OLE bridge?
Do you know how to solve it?

Thanks for any hints.

[Paolo F Cantoni]

Quick look suggests a data typing problem...

try: select instr('Tag:Value',':') + '1' AS C1 from dual;

You should get '41' from both...

(Fingers crossed)  

Isn't software wonderful?

HTH,
Paolo

[lubos]

OK I haven't described my goal :-)
I want to get  5 in EA search.

Thanks

[lubos]

I have overcome it by:

select instr('Tag:Value',':') - -1    as C1 from dual;

You'are right, software is wonderful ;-)

Still interesting in more appropriate solution...

[Geert Bellekens]

OK I haven't described my goal :-)
I want to get  5 in EA search.

Thanks

have you tried

Code: [Select]

select 5 as C1 from dual

Geert

[Geert Bellekens]

For your information,

On SQL Server both (ran through EA search)

Code: [Select]

select CHARINDEX (':', 'Tag:Value') + '1' AS c1and

Code: [Select]

select CHARINDEX (':', 'Tag:Value') + 1 AS c1result in 5

Geert

[lubos]

It's interesting,
I still have the result 41 in EA search. It seems it's a problem of some driver bridge...
But the hack with '- -' works so I will not continue to try to discover it.

Thanks