Declaring Object Types in a PL/SQL Block
DECLARE
emp EMPLOYEE_TYP; -- emp is atomically null
BEGIN
-- call the constructor for employee_typ
emp := Employee_typ(315,'Francis','Logan','FLOGAN','555.777.2222',
'01-MAY-04','SA_MAN',11000,.15,101,110,Address_typ('376 Mission','San Francisco','CA','94222'));
dbms_output.Put_line(emp.first_name
||' '
||emp.last_name); -- display details
emp.Display_address(); -- call object method to display details
END;
/
OUTPUT:-
Francis Logan
Francis Logan
376 Mission
San Francisco, CA 94222
PL/SQL procedure successfully completed.
Posts
0 comments:
Post a Comment