Skip to main content

NOCOPY Parameter Hint in PL/SQL

Before we get to understanding the NOCOPY parameter hint in PL/SQL, it would help to first look at PL/SQL parameter modes and the ways in which they pass values in and out of a subprogram.



Passing Parameter by Value

PL/SQL subprograms have three parameter modes:

  1. IN parameter mode is used to send values into the subprogram from the calling program. An IN parameter can only be read, its value cannot be modified inside the subprogram.
  2. OUT parameter mode is used to return values from the subprogram to the calling program.
  3. IN OUT parameter mode is a hybrid of IN and OUT. It is used to send values into the subprogram, and its value can be modified within the subprogram. On exit, the subprogram returns the updated value of the IN OUT parameter to the calling program. 
Continue reading at
Source :  NOCOPY Parameter Hint in PL/SQL

Comments

Popular posts from this blog

What is Bitnami ?

                                            What is Bitnami ? Bitnami makes it easy to run your favorite server apps anywhere Bitnami is a library of popular server applications and development environments that can be installed with one click, either in your laptop, in a virtual machine or hosted in the cloud. We take care of compiling and configuring the applications and all of their dependencies (third-party libraries, language runtimes, databases) so they work out-of-the-box. The resulting packaged software (a 'stack') is then made available as native installers, virtual machines and cloud images. These Bitnami application packages provide a consistent, secure and optimized end-user experience when deploying any app, on any platform. Bitnami Cloud Hosting Bitnami Cloud Hosting is a server management solution that makes it incredibly simple to launch and...