Have you tried to set
command.CommandType = CommandType.StoredProcedure;
I think the default is
CommandType.Text
[Update]
ORA-06512: This error is caused by the stack being unwound by unhandled exceptions in your PLSQL code.
ORACLE/PLSQL: ORA-06512[
^]
I think your c# code is ok, but the stored procedure throws an exception.
That might be because you are not matching the input parameters properly or that if no data is found, the SP doesn't return, but continues to execute with uninitialized variables.
Without seeing your SP declaration and SQL code, it is very difficult to help you.
Quote:
the function takes 3 input parameters and return one integer value.
The info above is not very useful without type information.
A variable with a name like this
videosListWithCommaSeparated
also raises suspicions when the internal SP code is unknown. Comma separated lists can be a cause of problems.