Guest User

Untitled

a guest
Jan 22nd, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.71 KB | None | 0 0
  1. DECLARE
  2. p_status VARCHAR2 (4) := 'S';
  3. p_id NUMBER := 123456;
  4. p_py_id NUMBER := 513;
  5. p_type NUMBER := 1;
  6. p_date_time DATE := TO_DATE ('10/01/2018 23:50:42', 'DD/MM/YYYY HH24:MI:SS');
  7. p_os_pay NUMBER := 0;
  8. p_ind VARCHAR2 (2) := 'Y';
  9. p_confirm VARCHAR2 (2) := 'Y';
  10. p_year NUMBER := 2018;
  11. p_reason VARCHAR2 (5) := NULL;
  12. p_currrpay NUMBER := 1517;
  13.  
  14. p_details pkg.g_r_type;
  15.  
  16. BEGIN
  17. p_details.pro_code := 'AB';
  18. p_details.inst_type := '1';
  19. p_details.pay_date := TO_DATE ('19/10/2016 00:00:00', 'DD/MM/YYYY HH24:MI:SS');
  20. p_details.pay_amt := 5000;
  21. p_details.h_code := 'ABCD';
  22. p_details.pay_ind := 'N';
  23. p_details.c_code := 123456;
  24. p_details.c_year := 8;
  25.  
  26.  
  27. pkg.procedure_info ( p_status,
  28. p_id,
  29. p_py_id,
  30. p_type,
  31. p_date_time,
  32. p_os_pay,
  33. p_ind,
  34. p_confirm,
  35. p_year,
  36. p_reason,
  37. p_details,
  38. p_currrpay
  39. );
  40. EXCEPTION
  41. WHEN OTHERS
  42. THEN
  43. DBMS_OUTPUT.put_line (SQLERRM);
  44. END;
  45. /
  46.  
  47. Below is the package description :
  48.  
  49. CREATE OR REPLACE package pkg
  50. as
  51. type g_r_type is record (
  52. pro_code varchar2 (2)
  53. ,inst_type varchar2 (1)
  54. ,pay_date date
  55. ,pay_amt number (13, 2)
  56. ,h_code varchar2 (4)
  57. ,pay_ind varchar2 (1)
  58. ,c_code number(6)
  59. ,c_year number(2)
  60. );
  61.  
  62.  
  63. procedure procedure_info (
  64. p_status in varchar2
  65. ,p_id in number
  66. ,p_py_id in number
  67. ,p_type in number
  68. ,p_date_time in date
  69. ,p_os_pay in number
  70. ,p_ind in varchar2
  71. ,p_confirm in varchar2
  72. ,p_year in number
  73. ,p_failure_reason in varchar2
  74. ,p_details in g_r_type
  75. ,p_currrpay in number
  76. );
  77. end pkg;
  78. /
Add Comment
Please, Sign In to add comment