[jira] [Commented] (HIVE-11881) Supporting HPL/SQL Packages

["Dmitry Tolpeko (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14906374#comment-14906374 ] 

Dmitry Tolpeko commented on HIVE-11881:
---------------------------------------

For example, package specification:

{code}
create or replace package pack1 as
  a int := 3;
  function f1 (p1 number, p2 number) return number; 
  procedure sp1(p1 number);
end;
{code}

Package body:

{code}
create or replace package body pack1 as
  function f1 (p1 number, p2 number) return number
  is
    begin
      return p1 + p2 + a;
    end;    
    
  procedure sp1(p1 number) 
  is
    begin
      dbms_output.put_line('a: ' || a);
      print 'p1: ' || p1;
    end;
end;
{code}

Use of the package:

{code}
dbms_output.put_line('pack1.a: ' || pack1.a);
dbms_output.put_line(pack1.f1(3,5));
pack1.sp1(1);
{code}

> Supporting HPL/SQL Packages
> ---------------------------
>
>                 Key: HIVE-11881
>                 URL: https://issues.apache.org/jira/browse/HIVE-11881
>             Project: Hive
>          Issue Type: Improvement
>          Components: hpl/sql
>            Reporter: Dmitry Tolpeko
>            Assignee: Dmitry Tolpeko
>
> HPL/SQL should support packages similar to Oracle PL/SQL.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)