Update fails to compile stored procedure

Update fails to compile stored procedure

References

Reference NO 1

http://stackoverflow.com/questions/13588869/update-fails-to-compile-stored-procedure

Reference NO 2

http://www.orafaq.com/forum/t/98868/2/

Reference NO 3

http://technet.microsoft.com/en-us/library/ms190439.aspx

Reference NO 4

https://www-304.ibm.com/connections/forums/html/topic?id=191eb09c-8bf2-440b-a92f-2e6b4d7a51b7

Reference NO 5

http://www.sqlhub.com/2011/10/some-facts-about-stored-procedure.html

Reference NO 6

http://forums.teradata.com/forum/enterprise/compiling-stored-proc-vc-not-installed-error

Reference NO 7

http://www.toadworld.com/thread/9975.aspx

Reference NO 8

http://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_pc.htm