Calling a SP with OCI which returns a Cu

[yodafan]

hi,

can anybody help me with this little prob?

I'm calling a Stored Procedure which returns a Cursor, everything seems to work fine except that I get an errormessage like this everytime I run my script:

Warning: OCIStmtExecute: ORA-24365: error in character conversion

I mean, I guess I could put an @ before the function which is causing the problem, but that's not really a good solution, now is it. Anyway, is there anybody out there who can help me I would be very grateful.

(Patrik alias Yodafan)

---

here goes the PHP code:

$cursor = OCINewCursor($connection);
$stmt = OCIParse($connection,"BEGIN SP_Administration.Select_Annee(:p_cursor, :p_errorcode); END;");

OCIBindByName($stmt,"p_cursor",&$cursor,-1,OCI_B_CURSOR);
OCIBindByName($stmt,"p_errorcode",&$errorcode,32);

THE PROBLEM OCCURS HERE--> OCIExecute($stmt);

OCIExecute($cursor);

---

while (OCIFetchInto($cursor, &$values)){

---

---
}

and so on.......

---

here goes the SP:

I have declared a package containing the procedure and a defintion of livrecur.

PROCEDURE Select_Annee(p_cursor OUT livrecur,p_errorcode OUT NUMBER) IS
BEGIN
p_errorcode := 0;
OPEN p_cursor FOR
SELECT annee
FROM ouvrages
GROUP BY annee
ORDER BY annee DESC;

EXCEPTION
WHEN OTHERS THEN
p_errorcode:= SQLCODE;

END Select_Annee;