$ cat table_ddl.sql ##################################################################### ## proc_ddl.sql ## ##################################################################### CREATE OR REPLACE PROCEDURE "SCOTT"."DELETE_SESSION" delete_session (sessionID IN VARCHAR2, returnCode OUT NUMBER) AS BEGIN DELETE FROM session WHERE session_id = sessionID; COMMIT; returnCode := 0; EXCEPTION WHEN OTHERS THEN DECLARE error_code NUMBER := SQLCODE; BEGIN IF error_code = -1000 THEN returnCode := 1; ELSE returnCode := SQLCODE; END IF; ROLLBACK; END; END delete_session; ;