Generating a Oracle SQL Cursor from a user entered SQL Query

You can write like this-


  string str = TextBox1.Text;// "SELECT a, b, c FROM TABLE t WHERE t.d = d_ AND t.e = e_";
        string[] st = new string[str.Split('=').Length - 1];

        for (int i = 1; i < str.Split('=').Length; i++)
            st[i - 1] = str.Split('=')[i].Trim().Split(' ')[0].ToString();


        string cursor = "CURSOR get_data(";

        for (int i = 0; i < st.Length; i++)
        {
            cursor += st[i] + "datatype ,";
        }
        cursor= cursor.Substring(0, cursor.Length-1);
        cursor += ")

" + str;

        Response.Write(cursor);
------------------------------------------------
output will be-
------------------------------------------------

CURSOR get_data(d_datatype ,e_datatype )

SELECT a, b, c FROM TABLE t WHERE t.d = d_ AND t.e = e_