For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all I have an application with an Authentication Schema (Http Variable) which is working fine, even the post-authentication procedure doesn't return any error because when i log in, apex give me a correct session and i can go in any page. However, when i try to filter to any column of any interactive report of any page, apex return this error: "Your session has ended" and doesn't apply any filter on the relative interactive report. If i activate debug e view it, the result is this It seems that the action of showing page is done correctly with the logged user ("TINIT -....") but the action of clicking on column to filter on it, that is a Ajax plugin request, is done anonymously, as if the application doesn't recognize the active session for the user: this is the detail of the Ajax plugin request with the error: Someone have any idea to resolve that error? Thank you in advance.
DataTable emptable = new DataTable(); string oradb = "Data Source = (DESCRIPTION =" + "(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = olisa-VAIO)(PORT = 1521)))" + "(CONNECT_DATA= (SERVER = DEDICATED)(SERVICE_NAME = XE)));" + "User Id = finance; Password=financecc;"; OracleConnection conn = new OracleConnection(oradb); conn.Open(); string sql = "select ID, Create_date from t_mobile"; OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; emptable.Load(cmd.ExecuteReader()); GridView1.DataSource = emptable; GridView1.DataBind(); conn.Close(); conn.Dispose();
protected void Button1_Click(object sender, EventArgs e) { DataTable emptable = new DataTable(); string oradb = "Data Source=(DESCRIPTION =" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=olisa-VAIO)(PORT=1521)))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)));" + "User Id = finance; Password=financecc;"; OracleConnection conn = new OracleConnection(oradb); conn.Open(); string sql = "select ID, Create_date from t_mobile"; OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; emptable.Load(cmd.ExecuteReader()); GridView1.DataSource = emptable; GridView1.DataBind(); conn.Close(); conn.Dispose(); }