I created a Table Function "my_tf" that has a parameter of type Date as input.
I use "my_tf" in the view "my_view".
When I try to take a select with an Order By criteria on the view:
Order By my-field;
I have the following error:
ORA-03113 end-of-file on communication channel
Can anyone help me? I know that the problem is the Table Function, because I try the View without the use of the Table Function. Any Idea of the problem?
Thanks in advance.
I know that the error is related to connection issue.
But for some reason that I don't konw the use of the Table Function cause this error. Maybe there is a problem oh the Table Function; but if query on the Table Function I have the correct result.