tag:blogger.com,1999:blog-7325550215422085906.post3314590852329724381..comments2024-03-28T12:51:00.793+05:30Comments on DATAWAREHOUSE CONCEPTS: How to Create a Procedure with both IN and OUT ParameterUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7325550215422085906.post-59798614521975817342013-05-15T00:21:14.988+05:302013-05-15T00:21:14.988+05:30A NOCOPY hints can be added to improve the perform...A NOCOPY hints can be added to improve the performance <br />(create or replace procedure ORDERDETAILS(orno in varchar2,b in out NOCOPY varchar2)<br /><br />Using the NOCOPY hint tells the compiler to use pass by reference, <br />so no temporary buffer is needed and no copy forward and copy back operations happen. <br />Instead, any modification to the parameter values are written directly to the parameter variable .<br />...https://www.blogger.com/profile/13263034724311530062noreply@blogger.com