Answered Questions

  • Mar 19 2007
    05:48 AM
    42393
    36

    what is the use of nocopy parameter in oracle procedure
    • ily_saravanan

    Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P

    Himansu

    • Nov 6th, 2012

    In procedure,Function there are three types of parameter is there. eg-IN, OUT, INOUT. IN parameter is call by reference and OUT & INOUT are call by value. Always call by reference is faster than call ...

    Saket

    • Apr 3rd, 2012

    Pass by reference: "IN" Case
    Pass by value : "Out" or "IN OUT" Case which have the overhead of copying the value to new procedure parameter.
    In order to make to Pass by reference we will use NOCOPY
    Pass by reference: "OUT NOCOPY" or "IN OUT NOCOPY" which deals which the actual reference value.