Execution of PL/SQL Package Subprograms

 Database triggers, stored subprograms, 3GL application programs, and Oracle tools can reference package contents.

data analytics


The following graphic shows database applications invoking procedures and functions in the employees_management package.

digital transformation


Figure 8-2 Calling Subprograms in a PL/SQL Package

Description of Figure 8-2 follows
Description of "Figure 8-2 Calling Subprograms in a PL/SQL Package"
erp

Database applications explicitly call packaged procedures as necessary. After being granted the privileges for the employees_management package, a user can explicitly run any of the procedures contained in it. For example, SQL*Plus can issue the following statement to run the hire_employees package procedure:

feature

EXECUTE employees_management.hire_employees ('TSMITH', 'C

Comments

Post a Comment

Popular posts from this blog

MICROSOFT SYSTEM CENTER TROUBLESHOOTING AND MAINTENANCE SERVICES COMPANY MALAYSIA

  MICROSOFT SYSTEM CENTER TROUBLESHOOTING AND MAINTENANCE SERVICES COMPANY MALAYSIA For more than 19 years, we have helped transform businesses worldwide by developing robust and scalable applications. Our E2E application services are undertaken through matured and proven agile processes to deliver cutting-edge applications. This involves identifying the solution required by the customer, assembling the right team, and implementing the solution through a structured Define, Design, Develop and Deploy (4D) methodology. https://www.ultronit.com.my/microsoft-system-center-troubleshooting-and-maintenance-services-company-malaysia/
Read more

LEADING AND BEST IOS APP DEVELOPMENT COMPANY MALAYSIA

  LEADING AND BEST IOS APP DEVELOPMENT COMPANY MALAYSIA WE DEVELOP SECURE ENTERPRISE IOS APPS. Our intuitive, well-designed, and functional apps make us one of the world’s premier iOS app development companies and a leader in the technology industry. MAJOR BRANDS TO LOOK TO US TO INTEGRATE THE POWER OF BLE INTO THEIR BUSINESS, REACHING THE RIGHT PEOPLE AT THE RIGHT TIME. https://www.ultronit.com.my/leading-and-bset-ios-app-development-company-malaysia
Read more