How to run and debug Oracle stored procedures

1. The steps for compiling an Oracle stored procedure are as follows:

1. Create or replace procedure P_AUTO_CREATE_PARTITION
2. (Result Out int,
3. LogErrDesc Out varchar2
4. )
5. Is
6. Type TypeTable is table of varchar2 (20 );
7. CreatePartitionErr exception;
8. Days TypeTable;
9. BEGIN
10. Result:=0;
11. Select datetime bulk collect into days FROM
12. (
13. SELECT TO_CHAR (TRUNC (SYSDATE-2, 'dd'), 'yyyymmdd') AS DATETIME FROM DUAL
14. UNION
15. SELECT TO_CHAR (TRUNC (SYSDATE-1, 'dd'), 'yyyymmdd') AS DATETIME FROM DUAL
16. UNION
17. SELECT TO_CHAR (TRUNC (SYSDATE, 'dd'), 'yyyymmdd') AS DATETIME FROM DUAL
18. UNION
19. SELECT TO_CHAR (TRUNC (SYSDATE + 1, 'dd'), 'yyyymmdd') AS DATETIME FROM DUAL
20. UNION
21. SELECT TO_CHAR (TRUNC (SYSDATE + 2, 'dd'), 'yyyymmdd') AS DATETIME FROM DUAL
22. );
24. For I in 1 .. days. count loop
25. If bruce_partiton.CreatePartitions ('t_ CDT_1X_BASIC_Partion ', days (I ))<0Then raise CreatePartitionErr; end if;
26. End loop;
27. -- The name of bruce_partiton is incorrect. It should be bruce_partition.
29. Commit;
30. -- Exception Handling
31. EXCEPTION
32. WHEN CreatePartitionErr THEN rollback; Result:=-1; LogErrDesc:=SQLERRM; Commit; RETURN;
33. WHEN OTHERS THEN
34. Rollback;
35. Result:=-2;
36. LogErrDesc:='CDM _ CTCALLTRACEINFO_PRC_NEW Fail! '| Substr (dbms_utility.format_error_stack, 1,200 );
37. Commit;
38. RETURN;
39. END P_AUTO_CREATE_PARTITION;
40. /

2. debugging

Select a stored procedure in PL/SQL, right-click TEST, ADD DEBUGINFO,

3. Run the Program in the Program Window.