Extractvalue function not recognised
357723May 11 2009 — edited Apr 11 2011Hello,
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