Comments by Ambati Dilip (Top 33 by date)

Here it is how to create a new android plugin. But where as in the previous question it is how to convert existing native android code to plugin format there is difference.

Please give solution or suggestions if you know. And thanks it wont repeat again

Replace this line OracleParameter refcursor = new OracleParameter("P_CUST_WALL_ID", OracleDbType.Varchar2, ParameterDirection.Output); to

OracleParameter refcursor = new OracleParameter("WTTP_CUST_INFO", OracleDbType.Varchar2, ParameterDirection.Output);

Here is my solution tell me what is wrong , while executing it says invalid parameters.

WTTP_CUST_INFO wc = new WTTP_CUST_INFO();
wc.CUST_NAME = "Dilip";
wc.CUST_PHONE_NO = "4545121212";
wc.CUST_STR_ADDRESS = "blablalba";
wc.CUST_PST_ADDRESS = "blalbla";
wc.CUST_CITY = "Bangalore";
wc.EMAIL_ID = "dcccxxx@gmail.com";
wc.ID_TYPE = "Driving License";
wc.ID_NUMBER = "Bvvavava8";
wc.CUST_AC_NO = "";
wc.CUST_AC_BANK = "";
wc.CUST_AC_BRN_CODE = "";
wc.CREATED_BY = "Admin";
OracleConnection conn = new OracleConnection();
OracleCommand cmd = new OracleCommand();
// OracleConnection conn = new OracleConnection();
string strCon = ConnectionString;
OracleParameter Orstr1 = new OracleParameter("P_CUST_INFO", OracleDbType.Object, ParameterDirection.Input);
Orstr1.OracleDbType = OracleDbType.Object;
//Orstr1.UdtTypeName = "WTPKS_ACCOUT.P_CUST_INFO";
Orstr1.Value = wc;
// OracleParameter refcursor = new OracleParameter("P_CUST_WALL_ID", OracleDbType.RefCursor, ParameterDirection.Output);
OracleParameter refcursor = new OracleParameter("P_CUST_WALL_ID", OracleDbType.Varchar2, ParameterDirection.Output);
refcursor.Direction = ParameterDirection.Output;
refcursor.Size = 4000;
OracleParameter Success = new OracleParameter("str1", OracleDbType.Varchar2, ParameterDirection.Output);
Success.Direction = ParameterDirection.Output;
Success.Size = 4000;
OracleParameter SuccessMsg = new OracleParameter("str2", OracleDbType.Varchar2, ParameterDirection.Output);
SuccessMsg.Direction = ParameterDirection.Output;
SuccessMsg.Size = 4000;
cmd.Parameters.Add(Orstr1);
cmd.Parameters.Add(refcursor);
cmd.Parameters.Add(Success);
cmd.Parameters.Add(SuccessMsg);
conn.ConnectionString = strCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "WTPKS_ACCOUT_1.WTFN_GET_WALLET";
cmd.Connection = conn;
//cmd.CommandText = procedureName;
conn.Open();
// cmd.ExecuteNonQuery();

OracleDataReader rdr;
DataTable dt = new DataTable();
rdr = cmd.ExecuteReader();