-
-
Pragma Init Exception
What is Pragma Init Exception ? what is difference between user defined exception and init pragma exception. what is the use of it.
-
what is the use of nocopy parameter in oracle procedure
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
-
how to avoid the mutating error with sample program
Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample program to avoid the mutating error by using pl/sql table.Thanks Saravanan.P
-
Oracle referance cursor code
Hi,1. Iam looking for sample program for ref cursor. ref cursor can be associated with many select statements and we can use the ref cursor to return the multiple value from the procedure or function. how to use the ref cursor in a program to associate with many select statements.2. we can't use the %rowtype attribut to return the multiple from the procedure or function instead of ref cursor. if we...
-
-
-
-