'Oracle' Category
-
Exceptions in ORACLE PL/SQL
June 14, 2009Error or Warning of any kind is called as Exception in Oracle which can be predefined or user-defined. Predefined exceptions are raised implicitly by the system. User-defined exceptions must be raised explicitly by RAISE statements. To handle raised exceptions, we write separate routines called exception handlers There are four kinds of exceptions in PL/SQL they [...]
-
Calling a proc with Varray or Nested table as Input parameter from sql*plus
May 27, 2009Now lets call the Procedure in the package from SQL*PLUS passing four Employee numbers What do you think of this post?Awesome (0) Interesting (1) Useful (1) Boring (0) Sucks (0)