| name | value |
|---|---|
| name | EMP_MGMT.CREATE_DEPT |
| created | 12/1/2010 8:20:17 PM |
| modified | 12/1/2010 8:34:38 PM |
| status | VALID |
| temporary | N |
| generated | N |
| secondary | N |
| name | datatype | in/out |
|---|---|---|
| return value | NUMBER | OUT |
| DEPARTMENT_ID | NUMBER | IN |
| LOCATION_ID | NUMBER | IN |
exec EMP_MGMT.CREATE_DEPT(
my_DEPARTMENT_ID,
my_LOCATION_ID
);| name | object type | level |
|---|---|---|
| EMP_MGMT | package | 1 |
| EMPLOYEES_SEQ | sequence | 2 |
| DEPARTMENTS_SEQ | sequence | 2 |