Database reference - HR

HR -  procedures -  EMP_MGMT_TWO.HIRE

Description

none

Procedure properties

namevalue
nameEMP_MGMT_TWO.HIRE
created12/1/2010 9:09:08 PM
modified12/1/2010 9:09:08 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_TWO.HIRE(
    my_LAST_NAME,
    my_JOB_ID,
    my_MANAGER_ID,
    my_SALARY,
    my_COMMISSION_PCT,
    my_DEPARTMENT_ID
);

Dependency graph

EMP_MGMT_TWOHIRE

Objects that EMP_MGMT_TWO.HIRE depends on

nameobject typelevel
EMP_MGMT_TWOpackage1
EMPLOYEES_SEQsequence2
DEPARTMENTS_SEQsequence2



Documentation generated by SqlSpec