公开(公告)号：US20190065552A1

公开(公告)日：2019-02-28

申请号：US16117367

申请日：2018-08-30

Applicant: Oracle International Corporation

Inventor： MATTHIAS BRANTNER ,  LAURENT DAYNES ,  PIT FENDER ,  BENJAMIN SCHLEGEL ,  ANANTHA KIRAN KANDUKURI ,  HASSAN CHAFI ,  ERIC SEDLAR ,  JUERGEN CHRIST ,  LUCAS BRAUN ,  BASTIAN HOSSBACH ,  ALEXANDER ULRICH ,  HARSHAD KASTURE

IPC: G06F17/30

Abstract: Herein are computerized techniques for deploying JavaScript and TypeScript stored procedures and user-defined functions into a database management system (DBMS). In an embodiment, a computer generates a SQL call specification for each subroutine of one or more subroutines encoded in a scripting language. The generating is based on a signature declaration of the subroutine. Each subroutine comprises a definition of a stored procedure or a user-defined function. The computer packages the definition and the SQL call specification of each subroutine into a single bundle file. The definition and the SQL call specification of each subroutine are deployed into a DBMS from the single bundle file. Eventually, the SQL call specification of at least one subroutine is invoked to execute the definition of the subroutine in the DBMS.