err in function

[prodadmin]

Thanks ..i will try this

also i am getting new error after correcting this :

ora-00604: error occured at recursive SQL Leevle 1
ora-01400 : cannnot insert NULL into (sys.obj$"."NAME"