Click here to Skip to main content
15,915,864 members
Home / Discussions / C#
   

C#

 
GeneralRe: Icons Disapear from taskebar Pin
Xmen Real 26-Mar-09 4:02
professional Xmen Real 26-Mar-09 4:02 
AnswerRe: Icons Disapear from taskebar Pin
musefan26-Mar-09 4:13
musefan26-Mar-09 4:13 
GeneralRe: Icons Disapear from taskebar Pin
Cracked-Down26-Mar-09 4:18
Cracked-Down26-Mar-09 4:18 
GeneralRe: Icons Disapear from taskebar Pin
Cracked-Down26-Mar-09 3:51
Cracked-Down26-Mar-09 3:51 
GeneralRe: Icons Disapear from taskebar Pin
Henry Minute26-Mar-09 6:31
Henry Minute26-Mar-09 6:31 
AnswerRe: Icons Disapear from taskebar Pin
Eddy Vluggen26-Mar-09 9:21
professionalEddy Vluggen26-Mar-09 9:21 
GeneralRe: Icons Disapear from taskebar Pin
Cracked-Down26-Mar-09 18:00
Cracked-Down26-Mar-09 18:00 
QuestionCsharp with Oracle 10g Passing Arrays as an Output Parameter to the SP: Need Help URGENT Pin
srinivas_0626-Mar-09 2:52
srinivas_0626-Mar-09 2:52 
I have a SP with 3 input parameters and 2 ouput paraters. The output parameters are of type array. I needed to know how are these parameters passed to the SP. I have be trying to set different properites/size of the Output parameter but with no success.

Here is the code:
con.Open(); // Connection String

                    Oracle.DataAccess.Client.OracleCommand cmd = con.CreateCommand();
                    cmd.CommandText = "SP_Name";
                    cmd.CommandType = CommandType.StoredProcedure;

// Parameter List                    
Oracle.DataAccess.Client.OracleParameter p_emplid = new Oracle.DataAccess.Client.OracleParameter("p_emplid", OracleDbType.Varchar2, ParameterDirection.Input);
                    Oracle.DataAccess.Client.OracleParameter p_start_date = new Oracle.DataAccess.Client.OracleParameter("p_start_date", OracleDbType.Date, ParameterDirection.Input);
                    Oracle.DataAccess.Client.OracleParameter p_end_date = new Oracle.DataAccess.Client.OracleParameter("p_end_date", OracleDbType.Date, ParameterDirection.Input);

                    Oracle.DataAccess.Client.OracleParameter p_O_EMPLID = new Oracle.DataAccess.Client.OracleParameter("p_O_EMPLID", OracleDbType.Varchar2, ParameterDirection.Output);
                    Oracle.DataAccess.Client.OracleParameter p_O_EFFDT = new Oracle.DataAccess.Client.OracleParameter("p_O_EFFDT", OracleDbType.Date, ParameterDirection.Output);

                    p_emplid.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
                    p_O_EMPLID.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
                    p_O_EFFDT.CollectionType = OracleCollectionType.PLSQLAssociativeArray;

                // Program Logic Starts Here    
		string[] Arremplid = new string[lstEmployeesRostered.Count()];
                 
                    for (int counter = 0; counter <= lstEmployeesRostered.Count() - 1; counter++)
                    {
                        Arremplid[counter] = lstEmployeesRostered.ElementAt(counter);
                    }
		// Program Logic Ends Here

                    p_emplid.Value = Arremplid;
                    p_start_date.Value = Convert.ToDateTime(Session["SMStartDate"]).ToString("dd-MMM-yyyy");
                    p_end_date.Value = Convert.ToDateTime(Session["EMEndDate"]).ToString("dd-MMM-yyyy");
                    p_O_EMPLID.Value = DBNull.Value;
                    p_O_EFFDT.Value = DBNull.Value;

                    p_emplid.Size = lstEmployeesRostered.Count();
	            p_O_EMPLID.Value = 1;
                    p_O_EFFDT.Value = 1;
                   

                    // add parameters to command object collection
                    cmd.Parameters.Add(p_emplid);
                    cmd.Parameters.Add(p_start_date);
                    cmd.Parameters.Add(p_end_date);
                    cmd.Parameters.Add(p_O_EMPLID);
                    cmd.Parameters.Add(p_O_EFFDT);

                    cmd.ExecuteNonQuery(); // I get an error After this



ERROR MESSAGE : OracleParameter.ArrayBindSize is invalid
Questionsend the xml through socket Pin
lnmca26-Mar-09 2:14
lnmca26-Mar-09 2:14 
AnswerRe: send the xml through socket Pin
stancrm26-Mar-09 2:32
stancrm26-Mar-09 2:32 
QuestionHow to display pdf & word file Pin
Sajjad Leo26-Mar-09 1:48
Sajjad Leo26-Mar-09 1:48 
AnswerRe: How to display pdf & word file Pin
Eddy Vluggen26-Mar-09 2:06
professionalEddy Vluggen26-Mar-09 2:06 
GeneralRe: How to display pdf & word file Pin
Sajjad Leo26-Mar-09 2:13
Sajjad Leo26-Mar-09 2:13 
GeneralRe: How to display pdf & word file Pin
musefan26-Mar-09 2:21
musefan26-Mar-09 2:21 
GeneralRe: How to display pdf & word file Pin
Sajjad Leo26-Mar-09 2:24
Sajjad Leo26-Mar-09 2:24 
GeneralRe: How to display pdf & word file Pin
Fayu26-Mar-09 2:49
Fayu26-Mar-09 2:49 
QuestionDate Time Pin
Zeyad Jalil26-Mar-09 1:41
professionalZeyad Jalil26-Mar-09 1:41 
AnswerRe: Date Time Pin
SeMartens26-Mar-09 1:47
SeMartens26-Mar-09 1:47 
GeneralRe: Date Time Pin
Zeyad Jalil26-Mar-09 2:05
professionalZeyad Jalil26-Mar-09 2:05 
GeneralRe: Date Time Pin
Ashfield26-Mar-09 2:12
Ashfield26-Mar-09 2:12 
GeneralRe: Date Time Pin
Deresen26-Mar-09 2:13
Deresen26-Mar-09 2:13 
GeneralRe: Date Time Pin
musefan26-Mar-09 2:17
musefan26-Mar-09 2:17 
GeneralRe: Date Time Pin
CPallini26-Mar-09 3:23
mveCPallini26-Mar-09 3:23 
QuestionNew project... which architecture? Pin
Mkyassuo26-Mar-09 1:25
Mkyassuo26-Mar-09 1:25 
AnswerRe: New project... which architecture? Pin
SeMartens26-Mar-09 1:38
SeMartens26-Mar-09 1:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.