Hi Manjunathk,

I am new to PL/SQL also (ok, very new) but I was wondering if the problem could be with the parameter?

The default mode for parameters is IN, which can't be modified in the procedure. They are treated like constants within the procedure. Both OUT and IN OUT parameter modes can be written to, though.

Good luck with this!

Mary