<%@ page language="PL/SQL" %>
<%@ plsql procedure="dept_insert_act" %>
<%@ plsql parameter="p_deptno" type="NUMBER" default="NULL" %>
<%@ plsql parameter="p_dname" type="VARCHAR2" default="NULL" %>
<%@ plsql parameter="p_loc" type="VARCHAR2" default="NULL" %>
<%@ plsql parameter="p_submit" type="VARCHAR2" default="NULL" %>
Insert DEPT
Insert DEPT
<%
BEGIN
INSERT INTO dept (deptno, dname, loc)
VALUES (p_deptno, p_dname, p_loc);
COMMIT;
HTP.Print(' Insert DEPT Completed Successfully!
');
EXCEPTION
WHEN OTHERS THEN
HTP.Print(' Error: ' || SQLERRM || '
');
END;
%>
<% Owa_Util.CellsPrint('SELECT * FROM dept'); %>