I have a problem regarding calling stored procedure from Oracle database. The procedure takes one parameter: phone_number (varchar2) and returns two values: out_1(varchar2) and out_2(varchar2). The database is located on remote host and is managed by administrators I don't know, so I can't see any logs of the database. So when I launch my application - connectivity sets up well, but calling remote procedure always returns "null". I use Oracle ODT with ODAC(32bit) in my .Net application.
I've written a simple application in python that uses the stored procedure and it retrieves data correctly, so there id definitely no problem with database or stored procedure. Here is a C# code:
public partial class Form1 : Form