469,072 Members | 1,845 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,072 developers. It's quick & easy.

No copy Parameter

Dear Guys,

My Oracle version is 10G.I have an some doubts in No copy Parameter.
I searching in google not getting Perfect answers.Am a new guy for this forums.
Any body give an instruction ,what's the purposes os NO copy parameter and
give an example program for No copy parameter is better.

I expecting Your replies...

Aug 1 '07 #1
3 1662
8,127 Expert 4TB
As you have posted a question in the article section it is being moved to Oracle Forum.

Aug 2 '07 #2
NO COPY Parameter: A Compiler Hint

we usually use this no copy with OUT and IN OUT parameters..that is they are call- by- value parameters,and IN parameter is the call-by-reference parameter,

To make OUT and IN OUT parameters as call-by-reference we use a Compiler Hint called NO COPY

Generally we Use this NO COPY when we are using Collections in a procedure where we are going to fetch a large volumes of data and returning to the user,instead of fecthing and OUT the by values we just pass them by reference.

The time taken to return output will be drastically reduced
Aug 19 '07 #3
2,367 Expert 2GB
NO COPY also reduces the use of memory, because we are gonna PASS the parameter by reference rather by value so both the formal and actual parameters references the same memory location thus reducing memory usage.
When the parameter is passed by reference, the computed value in the procedure will be written to actual parameters only after the complete execution of the procedure.
Aug 20 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by prashna | last post: by
8 posts views Thread by Jesper | last post: by
4 posts views Thread by Peter | last post: by
6 posts views Thread by kjm424 | last post: by
3 posts views Thread by subramanian | last post: by
2 posts views Thread by bandito40 | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.