Thursday, November 28, 2013

Script to Create PL/SQL Pakcgage

Creating pl/sql package has two simple step . First create package name and needed function/procedure declaration .
CREATE OR REPLACE PACKAGE XML_PARSER AS
  
   FUNCTION PARSE_ACCOUNT_INFO RETURN VARCHAR2;
    
END XML_PARSER;
/

Second Step : Creating package body with actual implementation of function/procedure previously defined in creation of package.
CREATE OR REPLACE PACKAGE BODY XML_PARSER AS

  FUNCTION PARSE_ACCOUNT_INFO RETURN VARCHAR2 IS 
    TEMP VARCHAR2(10);
    BEGIN
      NULL;
    END;


END XML_PARSER;
/



No comments:

Post a Comment