DevOps, CI/CD and Automation

Hello,

I'm trying to compile a pro*c program against a 10.2.0.3.0 Oracle DB.
The precompiler does not seem to recognise the EXCTRACTVALUE function since I'm getting the following error:

Error at line 283, column 7 in file MainCheckNat.pc
EXEC SQL
......1
PLS-S-00201, identifier 'EXTRACTVALUE' must be declared

The query looks like:

EXEC SQL
SELECT COUNT(DISTINCT EXTRACTVALUE(segnalazione, '/TransactionError/TransactionReferenceNumber'))
INTO :hostvar1
FROM table
WHERE id_file = :hostvar2
;

I have searched the pro*c programming manual for some hints but I could not find any.

Has anybody ever met with this problem before?
Or is there anything I am doing the wrong way?

Thanks,
Massimo