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

Post a Comment

Popular posts from this blog

The Miraculous Plants

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 ...
Post a Comment
Read more

Green planet

Fifty years ago green was just a colour .Now it’s a way of looking at our world .But how green is our planet today? Planet earth On February 2002, scientists in kourou, French Guiana, were worried. They knew that in a few hours ‘time the Arianne rocket would leave on its journey .on the rocket was Envisat, the biggest and most expensive satellite ever made in Europe .Envisat was ready and waiting after twenty years’ work by hundreds of people .but now , at the last minute, something was wrong with the rocket carrying the satellite. Scientists worked all night to get the rocket working again .late in the evening on 1march everyone in kourou stopped working to watch the rocket leave. The weather was good and the rocket was ready .five four three two one ......the Arianne rocket went up into the sky, carrying Envisat with it. What is special about Envisat? It is as big as a bus, and very heavy. It travels 800km above the earth, and it goes round the earth once every 100 minutes. Envisat g...
Post a Comment
Read more