PL/SQL (MOSC)

MOSC Banner

update employee using API

edited Jun 24, 2016 9:13AM in PL/SQL (MOSC) 8 commentsAnswered

Dear All,

im trying to update an employee using the API but unfortunately i got the below error:

"

SQL> Execute XX_update_empdata_api(0);
ORA-20001: The primary key specified is invalid

Cause:        The primary key
values specified are invalid and do not exist in the schema. 

Action:
Check the primary key values before attempting to carry out the operation again.

PL/SQL procedure successfully completed.

"

the code:

"

Create or replace PROCEDURE  XX_update_empdata_api (nb in number) IS

-- Local Variables

-- -----------------------

ln_object_version_number PER_ALL_PEOPLE_F.OBJECT_VERSION_NUMBER%TYPE  := 7;

lc_dt_ud_mode VARCHAR2(100) := NULL;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center