Clarify Funtion Doubt

[intelram_18]

Dear All,
I am using one function thats performs some updates and result is coming 1 while run directly in pl/sql developer , But when i call the function through select statement it gives a return value as 0 . kindly clarify whether is there any error in function or some other methods to execute function

[skhanal]

What function? Can you post the code?

[intelram_18]

Dear skhanal,
Thanks for ur reply . I find the problem it because of i use update statment with in function , so the error cames .Thank u once again for ur reply

[skhanal]

You can't use any DML statement in a function, write a stored procedure instead.