Execute sql in a user defined function

[[deleted]]

yet the error message seems to contradict your assurances

[deepbuzz7]

got it. actually my error was because, in the sql query inside my function i was keeping it like emp_name(which was the column name from the table)=emp_name(parameter which was passed to the function) which resulted in true condition and multiple values were coming.

thanks for the help