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.
PL/SQL subprograms have three parameter modes:
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.OUT parameter mode is used to return values from the subprogram to the calling program. 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
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 manage apps on Amazon Web Services. Users can launch all of the Bitnami application packages, build development environments, automate ba…
It was a very cold winter, with snow everywhere. For the eastern tribe, it was a terrible time .many people were sick and there was no medicine to help them .every day, people died .the leader didn't know what to do .his cute son, Bassou, was also very ill. If he couldn't help him, he was going to die, and thus the tribe will die out. The leader sat by his fire, but he didn't feel warm. ''It’s the end '', he thought.’ If he dies, I don't want to live '' he looked into the fire. The wood burnt noisily.
Suddenly, he remembered his wiser teacher, and he heard his fierce words ''you must save your son, and your tribe .go and look for the medicine! There is a medicine for everything. Go quickly! It will soon be too late '' The leader began his journey that night. He walked through the snow and the dark forest all night. In the morning, he was cold and hungry. '' How can I find the medicine plants which will hel…