{"id":535,"date":"2014-08-20T07:01:28","date_gmt":"2014-08-20T07:01:28","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=535"},"modified":"2014-08-20T07:03:58","modified_gmt":"2014-08-20T07:03:58","slug":"package-creation-in-oracle","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/package-creation-in-oracle\/","title":{"rendered":"Package Creation in oracle"},"content":{"rendered":"<p>Package creation in Oracle is a TWO step Process.<br \/>\n1.Declaration of Package<br \/>\n2.Definition of Package <\/p>\n<p><strong>Declaration of Package <\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n  CREATE OR REPLACE PACKAGE TEST IS\r\n    PROCEDURE JUNITPROC(C OUT SYS_REFCURSOR);\r\n  END TEST;\r\n<\/pre>\n<p><strong>Definition of Package <\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n  CREATE OR REPLACE PACKAGE BODY TEST IS\r\n  PROCEDURE JUNITPROC(C OUT SYS_REFCURSOR) IS\r\n  BEGIN  \r\n    OPEN C FOR\r\n      SELECT 78985450.1245487986418648 DECIMAL_VAL FROM DUAL;\r\n  END JUNITPROC;\r\nEND TEST;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Package creation in Oracle is a TWO step Process. 1.Declaration of Package 2.Definition of Package Declaration of Package CREATE OR REPLACE PACKAGE TEST IS PROCEDURE JUNITPROC(C OUT SYS_REFCURSOR); END TEST; Definition of Package CREATE OR REPLACE PACKAGE BODY TEST IS PROCEDURE JUNITPROC(C OUT SYS_REFCURSOR) IS BEGIN OPEN C FOR SELECT 78985450.1245487986418648 DECIMAL_VAL FROM DUAL; END&hellip; <a href=\"https:\/\/codethataint.com\/blog\/package-creation-in-oracle\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75],"tags":[],"class_list":["post-535","post","type-post","status-publish","format-standard","hentry","category-packages-procedures"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=535"}],"version-history":[{"count":2,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/535\/revisions"}],"predecessor-version":[{"id":537,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/535\/revisions\/537"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}