SQL Function doesn't work in one Outsystems environment

Hi, hope someone can help me....
I've been wasting time on this for several days, so here's the thing:
- I'm configuring a new OutSystems environment and migrating apps from another to this new (OS 10)

- So, of course, the code is exactly the same in both environments but they don't share the same db....

- In this new environment there are some sql functions that don't work (ex: Hextoraw(), Translate() ), if I test the queries in the advanced query they don't work, but if I remove the functions from the queries, it will work....

- If I test those queries in sqldeveloper (with the functions) it will work!

- Oracle versions and client are the same in both db and machines.....

Can someone have some idea of what can it be?

Can you share a bit more information, like the query and the error message? and perhaps the testdata. 

is it an external Oracle database, or just the OutSystems Oracle database? 

regards Hans

The query uses both an external Oracle database (via dblink) and the Outsystems oracle database...
I can't share the query sorry....but I can share the error with the hextoraw function query:

ORA-01465: Invalid Hex Number

mvp_badge
MVP

Hi João Coelho,

have you test the query with same data and input parameters which you have used in sql developer?

Regards,

Manish Jawla


Yes...and in Outsystems advanced query tool, and it works perfectly in one environment, but in the new one, it doesn't work...

are the database settings the same for the 2 databases, e.g. are they using the name NLS settings etc. And is the database connection the same? (you can see that in Service Center > Administration)

The NLS settings are the same in both database.

Using a dblink, called through internal sql in db, do I need to configure any database connection in Service Center??

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.