公开(公告)号：US11360976B2

公开(公告)日：2022-06-14

申请号：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: G06F16/2453 ,  G06F16/2455

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.