Database reference - HR

HR -  procedures -  EMP_MGMT.HIRE

Description

none

Procedure properties

namevalue
nameEMP_MGMT.HIRE
created12/1/2010 8:20:17 PM
modified12/1/2010 8:34:38 PM
statusVALID
temporaryN
generatedN
secondaryN

Parameters

namedatatypein/out
return value  NUMBER  OUT 
LAST_NAME  VARCHAR2  IN 
JOB_ID  VARCHAR2  IN 
MANAGER_ID  NUMBER  IN 
SALARY  NUMBER  IN 
COMMISSION_PCT  NUMBER  IN 
DEPARTMENT_ID  NUMBER  IN 

Usage

exec EMP_MGMT.HIRE(
    my_LAST_NAME,
    my_JOB_ID,
    my_MANAGER_ID,
    my_SALARY,
    my_COMMISSION_PCT,
    my_DEPARTMENT_ID
);

Dependency graph

EMP_MGMTHIRE

Objects that EMP_MGMT.HIRE depends on

nameobject typelevel
EMP_MGMTpackage1
EMPLOYEES_SEQsequence2
DEPARTMENTS_SEQsequence2



Documentation generated by SqlSpec