Click here to Skip to main content
15,882,658 members

Comments by Ambati Dilip (Top 33 by date)

Ambati Dilip 28-Apr-16 5:19am View    
try this window.open('url','_system'); it ask for browser option choose any one of them. PDF will open in browser
Ambati Dilip 27-Apr-16 0:34am View    
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.
Ambati Dilip 26-Apr-16 12:57pm View    
Please give solution or suggestions if you know. And thanks it wont repeat again
Ambati Dilip 6-Aug-15 3:07am View    
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);
Ambati Dilip 6-Aug-15 3:05am View    
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();