{"id":636,"date":"2026-07-23T05:53:27","date_gmt":"2026-07-23T05:53:27","guid":{"rendered":"https:\/\/mitalgoswami.in\/?p=636"},"modified":"2026-07-23T05:56:40","modified_gmt":"2026-07-23T05:56:40","slug":"package-in-oracle-pl-sql","status":"publish","type":"post","link":"https:\/\/mitalgoswami.in\/?p=636","title":{"rendered":"Package in Oracle PL\/SQL"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\"><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">What is a Package?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A <strong>Package<\/strong> is a database object that groups together related <strong>procedures, functions, variables, cursors, exceptions, and types<\/strong> into a single unit.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A package consists of two parts:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Package Specification (Declaration)<\/strong> \u2013 Declares public procedures, functions, variables, constants, cursors, etc.<\/li>\n\n\n\n<li><strong>Package Body (Implementation)<\/strong> \u2013 Contains the actual code for the procedures and functions declared in the specification.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Advantages of Packages<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Code Reusability<\/strong> \u2013 Group related program units together.<\/li>\n\n\n\n<li><strong>Modularity<\/strong> \u2013 Organizes code into logical modules.<\/li>\n\n\n\n<li><strong>Better Performance<\/strong> \u2013 Entire package is loaded into memory on first use.<\/li>\n\n\n\n<li><strong>Security<\/strong> \u2013 Hide implementation details in the package body.<\/li>\n\n\n\n<li><strong>Easy Maintenance<\/strong> \u2013 Modify the package body without changing the specification (if the interface remains the same).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Structure of a Package<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>Package\n\u2502\n\u251c\u2500\u2500 Package Specification\n\u2502      \u251c\u2500\u2500 Variables\n\u2502      \u251c\u2500\u2500 Constants\n\u2502      \u251c\u2500\u2500 Procedures\n\u2502      \u251c\u2500\u2500 Functions\n\u2502      \u2514\u2500\u2500 Cursors\n\u2502\n\u2514\u2500\u2500 Package Body\n       \u251c\u2500\u2500 Procedure Implementation\n       \u251c\u2500\u2500 Function Implementation\n       \u2514\u2500\u2500 Private Variables\/Procedures<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Syntax<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1: Create Package Specification<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE package_name AS\n\n    -- Variable\n    variable_name datatype;\n\n    -- Procedure Declaration\n    PROCEDURE procedure_name(parameter datatype);\n\n    -- Function Declaration\n    FUNCTION function_name(parameter datatype)\n    RETURN datatype;\n\nEND package_name;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2: Create Package Body<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE BODY package_name AS\n\n    PROCEDURE procedure_name(parameter datatype)\n    IS\n    BEGIN\n        -- Procedure code\n    END;\n\n    FUNCTION function_name(parameter datatype)\n    RETURN datatype\n    IS\n    BEGIN\n        -- Function code\n        RETURN value;\n    END;\n\nEND package_name;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 1: Simple Package<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Package Specification<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE employee_pkg AS\n\n    PROCEDURE display_message;\n\nEND employee_pkg;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Package Body<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE BODY employee_pkg AS\n\n    PROCEDURE display_message\n    IS\n    BEGIN\n        DBMS_OUTPUT.PUT_LINE('Welcome to Oracle Package');\n    END display_message;\n\nEND employee_pkg;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Execute<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>EXEC employee_pkg.display_message;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Welcome to Oracle Package<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 2: Package with Procedure and Function<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Employee Table<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>EMP_ID<\/th><th>EMP_NAME<\/th><th>SALARY<\/th><\/tr><\/thead><tbody><tr><td>101<\/td><td>Rahul<\/td><td>35000<\/td><\/tr><tr><td>102<\/td><td>Priya<\/td><td>42000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Package Specification<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE emp_pkg AS\n\n    PROCEDURE show_employee(p_empid NUMBER);\n\n    FUNCTION get_salary(p_empid NUMBER)\n    RETURN NUMBER;\n\nEND emp_pkg;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Package Body<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE BODY emp_pkg AS\n\n    PROCEDURE show_employee(p_empid NUMBER)\n    IS\n        v_name EMPLOYEE.EMP_NAME%TYPE;\n        v_salary EMPLOYEE.SALARY%TYPE;\n    BEGIN\n        SELECT EMP_NAME, SALARY\n        INTO v_name, v_salary\n        FROM EMPLOYEE\n        WHERE EMP_ID = p_empid;\n\n        DBMS_OUTPUT.PUT_LINE('Employee Name : ' || v_name);\n        DBMS_OUTPUT.PUT_LINE('Salary : ' || v_salary);\n\n    EXCEPTION\n        WHEN NO_DATA_FOUND THEN\n            DBMS_OUTPUT.PUT_LINE('Employee Not Found');\n    END;\n\n    FUNCTION get_salary(p_empid NUMBER)\n    RETURN NUMBER\n    IS\n        v_salary EMPLOYEE.SALARY%TYPE;\n    BEGIN\n        SELECT SALARY\n        INTO v_salary\n        FROM EMPLOYEE\n        WHERE EMP_ID = p_empid;\n\n        RETURN v_salary;\n    END;\n\nEND emp_pkg;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Execute Procedure<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>EXEC emp_pkg.show_employee(101);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Employee Name : Rahul\nSalary : 35000<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Execute Function<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\n    v_salary NUMBER;\nBEGIN\n    v_salary := emp_pkg.get_salary(101);\n\n    DBMS_OUTPUT.PUT_LINE('Salary = ' || v_salary);\nEND;\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Salary = 35000<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 3: Package Variable<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Package Specification<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE company_pkg AS\n\n    company_name VARCHAR2(50) := 'ABC Technologies';\n\nEND company_pkg;\n\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Use Package Variable<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN\n    DBMS_OUTPUT.PUT_LINE(company_pkg.company_name);\nEND;\n\/<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ABC Technologies<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Example 4: Private Procedure<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">A procedure declared <strong>only in the package body<\/strong> is <strong>private<\/strong> and cannot be called from outside the package.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE BODY employee_pkg AS\n\n    PROCEDURE private_message\n    IS\n    BEGIN\n        DBMS_OUTPUT.PUT_LINE('Private Procedure');\n    END;\n\n    PROCEDURE display_message\n    IS\n    BEGIN\n        private_message;\n    END;\n\nEND employee_pkg;\n\/<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Calling:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXEC employee_pkg.display_message;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Output:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Private Procedure<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Trying to execute:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXEC employee_pkg.private_message;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">will result in an error because <code>private_message<\/code> is not declared in the package specification.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">View Package Information<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">View Package Source<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT TEXT\nFROM USER_SOURCE\nWHERE NAME = 'EMP_PKG'\nORDER BY LINE;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">View All Packages<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT OBJECT_NAME\nFROM USER_OBJECTS\nWHERE OBJECT_TYPE = 'PACKAGE';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Drop Package<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP PACKAGE emp_pkg;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Difference Between Procedure and Package<\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Feature<\/th><th>Procedure<\/th><th>Package<\/th><\/tr><\/thead><tbody><tr><td>Definition<\/td><td>Single stored program<\/td><td>Collection of related procedures, functions, variables, cursors, and exceptions<\/td><\/tr><tr><td>Reusability<\/td><td>Limited<\/td><td>High<\/td><\/tr><tr><td>Organization<\/td><td>One task<\/td><td>Multiple related tasks<\/td><\/tr><tr><td>Performance<\/td><td>Loaded individually<\/td><td>Entire package loaded into memory on first use<\/td><\/tr><tr><td>Security<\/td><td>Cannot hide helper routines<\/td><td>Can hide private procedures\/functions in the package body<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Difference Between Package Specification and Package Body<\/h1>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Package Specification<\/th><th>Package Body<\/th><\/tr><\/thead><tbody><tr><td>Declares public objects<\/td><td>Implements the declared objects<\/td><\/tr><tr><td>Visible to users<\/td><td>Hidden implementation details<\/td><\/tr><tr><td>Acts as the package interface<\/td><td>Contains executable code<\/td><\/tr><tr><td>Must exist before the body<\/td><td>Cannot exist without the specification<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Advantages of Packages Structure of a Package Syntax Step 1: Create Package Specification Step 2: Create Package Body Example 1: Simple Package Package Specification [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-636","post","type-post","status-publish","format-standard","hentry","category-oracle"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"admin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/mitalgoswami.in\/?p=636\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Mital&#039;s Blog - My  Blog\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Package in Oracle PL\/SQL - Mital&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mitalgoswami.in\/?p=636\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-23T05:53:27+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-23T05:56:40+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Package in Oracle PL\/SQL - Mital&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#blogposting\",\"name\":\"Package in Oracle PL\\\/SQL - Mital's Blog\",\"headline\":\"Package in Oracle PL\\\/SQL\",\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\"},\"datePublished\":\"2026-07-23T05:53:27+00:00\",\"dateModified\":\"2026-07-23T05:56:40+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#webpage\"},\"articleSection\":\"oracle\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mitalgoswami.in\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30#listItem\",\"name\":\"oracle\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30#listItem\",\"position\":2,\"name\":\"oracle\",\"item\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#listItem\",\"name\":\"Package in Oracle PL\\\/SQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#listItem\",\"position\":3,\"name\":\"Package in Oracle PL\\\/SQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?cat=30#listItem\",\"name\":\"oracle\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\",\"name\":\"Mital's Blog\",\"description\":\"My  Blog\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a575ce1a3c064ed3befd825918c1c0457a92281570ba3e96c008e1c0af08ddc5?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#webpage\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636\",\"name\":\"Package in Oracle PL\\\/SQL - Mital's Blog\",\"description\":\"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \\u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \\u2013 Contains the actual code for the procedures and\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?p=636#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/?author=1#author\"},\"datePublished\":\"2026-07-23T05:53:27+00:00\",\"dateModified\":\"2026-07-23T05:56:40+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#website\",\"url\":\"https:\\\/\\\/mitalgoswami.in\\\/\",\"name\":\"Mital's Blog\",\"description\":\"My  Blog\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/mitalgoswami.in\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Package in Oracle PL\/SQL - Mital's Blog","description":"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and","canonical_url":"https:\/\/mitalgoswami.in\/?p=636","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mitalgoswami.in\/?p=636#blogposting","name":"Package in Oracle PL\/SQL - Mital's Blog","headline":"Package in Oracle PL\/SQL","author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"publisher":{"@id":"https:\/\/mitalgoswami.in\/#organization"},"datePublished":"2026-07-23T05:53:27+00:00","dateModified":"2026-07-23T05:56:40+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mitalgoswami.in\/?p=636#webpage"},"isPartOf":{"@id":"https:\/\/mitalgoswami.in\/?p=636#webpage"},"articleSection":"oracle"},{"@type":"BreadcrumbList","@id":"https:\/\/mitalgoswami.in\/?p=636#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in#listItem","position":1,"name":"Home","item":"https:\/\/mitalgoswami.in","nextItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?cat=30#listItem","name":"oracle"}},{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?cat=30#listItem","position":2,"name":"oracle","item":"https:\/\/mitalgoswami.in\/?cat=30","nextItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?p=636#listItem","name":"Package in Oracle PL\/SQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?p=636#listItem","position":3,"name":"Package in Oracle PL\/SQL","previousItem":{"@type":"ListItem","@id":"https:\/\/mitalgoswami.in\/?cat=30#listItem","name":"oracle"}}]},{"@type":"Organization","@id":"https:\/\/mitalgoswami.in\/#organization","name":"Mital's Blog","description":"My  Blog","url":"https:\/\/mitalgoswami.in\/"},{"@type":"Person","@id":"https:\/\/mitalgoswami.in\/?author=1#author","url":"https:\/\/mitalgoswami.in\/?author=1","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/mitalgoswami.in\/?p=636#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/a575ce1a3c064ed3befd825918c1c0457a92281570ba3e96c008e1c0af08ddc5?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"WebPage","@id":"https:\/\/mitalgoswami.in\/?p=636#webpage","url":"https:\/\/mitalgoswami.in\/?p=636","name":"Package in Oracle PL\/SQL - Mital's Blog","description":"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mitalgoswami.in\/#website"},"breadcrumb":{"@id":"https:\/\/mitalgoswami.in\/?p=636#breadcrumblist"},"author":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"creator":{"@id":"https:\/\/mitalgoswami.in\/?author=1#author"},"datePublished":"2026-07-23T05:53:27+00:00","dateModified":"2026-07-23T05:56:40+00:00"},{"@type":"WebSite","@id":"https:\/\/mitalgoswami.in\/#website","url":"https:\/\/mitalgoswami.in\/","name":"Mital's Blog","description":"My  Blog","inLanguage":"en-US","publisher":{"@id":"https:\/\/mitalgoswami.in\/#organization"}}]},"og:locale":"en_US","og:site_name":"Mital's Blog - My  Blog","og:type":"article","og:title":"Package in Oracle PL\/SQL - Mital's Blog","og:description":"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and","og:url":"https:\/\/mitalgoswami.in\/?p=636","article:published_time":"2026-07-23T05:53:27+00:00","article:modified_time":"2026-07-23T05:56:40+00:00","twitter:card":"summary_large_image","twitter:title":"Package in Oracle PL\/SQL - Mital's Blog","twitter:description":"What is a Package? A Package is a database object that groups together related procedures, functions, variables, cursors, exceptions, and types into a single unit. A package consists of two parts: Package Specification (Declaration) \u2013 Declares public procedures, functions, variables, constants, cursors, etc. Package Body (Implementation) \u2013 Contains the actual code for the procedures and"},"aioseo_meta_data":{"post_id":"636","title":"#post_title #separator_sa #site_title","description":"#post_excerpt","keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-07-23 05:53:46","updated":"2026-07-24 04:48:56","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mitalgoswami.in\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mitalgoswami.in\/?cat=30\" title=\"oracle\">oracle<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPackage in Oracle PL\/SQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/mitalgoswami.in"},{"label":"oracle","link":"https:\/\/mitalgoswami.in\/?cat=30"},{"label":"Package in Oracle PL\/SQL","link":"https:\/\/mitalgoswami.in\/?p=636"}],"_links":{"self":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=636"}],"version-history":[{"count":1,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/636\/revisions"}],"predecessor-version":[{"id":637,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/636\/revisions\/637"}],"wp:attachment":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}