PLS-00306: wrong number or types of arguments in call to 'UPDATE_COMPETENCE_ELEMENT' ORA-06550 State
I am trying to end date job competences by calling the HR_COMPETENCE_ELEMENT_API.UPDATE_COMPETENCE_ELEMENT API, but it seems to be returning an error "PLS-00306: wrong number or types of arguments in call to 'UPDATE_COMPETENCE_ELEMENT'".I have checked all the possible parameters to be called in the api and i have supplied values for the necessary ones and left the others null.
here is a sample script.
DECLARE
lc_errmsg VARCHAR2 (4000);
l_object_version_number NUMBER;
CURSOR CURSOR1
IS
SELECT *
FROM per_competence_elements pce
WHERE TYPE = 'REQUIREMENT' AND pce.JOB_ID = 53854;
BEGIN
FOR i IN CURSOR1
Tagged:
0