Click here to Skip to main content
14,879,723 members
Home / Discussions / Database
   

Database

 
GeneralRe: Find Last Record In Sequence Pin
Blue_Boy26-Jul-11 2:35
MemberBlue_Boy26-Jul-11 2:35 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 2:39
MemberAdam Jasper26-Jul-11 2:39 
GeneralRe: Find Last Record In Sequence Pin
Blue_Boy26-Jul-11 2:41
MemberBlue_Boy26-Jul-11 2:41 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 3:16
MemberAdam Jasper26-Jul-11 3:16 
GeneralRe: Find Last Record In Sequence Pin
Blue_Boy26-Jul-11 3:29
MemberBlue_Boy26-Jul-11 3:29 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 3:33
MemberAdam Jasper26-Jul-11 3:33 
AnswerRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 3:48
MemberAdam Jasper26-Jul-11 3:48 
QuestionOracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() interrupts execution of the whole program [modified] Pin
NandoMan25-Jul-11 11:51
MemberNandoMan25-Jul-11 11:51 
Hello people of CP,

I have a problem and would like you to help me fix it.

The problem is that right after I call a stored procedure calling the method stated in the title, the execution of the program is interrupted without any warning or prompt whatsoever.

The code block is this:

public virtual object Execute()
      {         return this.command.ExecuteNonQuery();
      }


I know the command executes because the state in the DataBase is changed. But right after the return this.command.ExecuteNonQuery(); line, the program just stops. It doesn't throw an exception, it doesn't even go to the last bracket of the method, the program just exits.

So, any idea what this might be?

Thanks a lot!

Edit:

Here's a clearer example:

private void SetSystemEnviroment()
        {
            try
            {
                using (OracleCommand command = this.con.CreateCommand())
                {
                    command.CommandText = "SetSystemEnviroment";
                    command.CommandType = CommandType.StoredProcedure;

                    command.ExecuteNonQuery();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }


Again, after the command.ExecuteNonQuery(); line, it just stops the execution of the program, no warnings, no exceptions, nothing.

modified on Monday, July 25, 2011 6:23 PM

GeneralRe: Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() interrupts execution of the whole program Pin
Shameel31-Jul-11 7:25
professionalShameel31-Jul-11 7:25 
AnswerRe: Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() interrupts execution of the whole program Pin
Herman<T>.Instance1-Aug-11 3:52
MemberHerman<T>.Instance1-Aug-11 3:52 
QuestionSingle row for multiple results Pin
vanikanc22-Jul-11 7:54
Membervanikanc22-Jul-11 7:54 
AnswerRe: Single row for multiple results Pin
Blue_Boy22-Jul-11 8:20
MemberBlue_Boy22-Jul-11 8:20 
GeneralRe: Single row for multiple results Pin
vanikanc22-Jul-11 8:27
Membervanikanc22-Jul-11 8:27 
GeneralRe: Single row for multiple results Pin
Blue_Boy22-Jul-11 8:28
MemberBlue_Boy22-Jul-11 8:28 
AnswerRe: Single row for multiple results Pin
Tim Carmichael22-Jul-11 8:28
MemberTim Carmichael22-Jul-11 8:28 
GeneralRe: Single row for multiple results Pin
vanikanc22-Jul-11 8:42
Membervanikanc22-Jul-11 8:42 
AnswerRe: Single row for multiple results Pin
Shameel22-Jul-11 9:00
professionalShameel22-Jul-11 9:00 
AnswerRe: Single row for multiple results Pin
PIEBALDconsult23-Jul-11 14:07
professionalPIEBALDconsult23-Jul-11 14:07 
AnswerRe: Single row for multiple results Pin
Niladri_Biswas24-Jul-11 22:37
MemberNiladri_Biswas24-Jul-11 22:37 
SuggestionRe: Single row for multiple results Pin
_Zorro_25-Jul-11 4:22
professional_Zorro_25-Jul-11 4:22 
GeneralRe: Single row for multiple results Pin
vanikanc25-Jul-11 5:22
Membervanikanc25-Jul-11 5:22 
GeneralRe: Single row for multiple results Pin
_Zorro_25-Jul-11 6:20
professional_Zorro_25-Jul-11 6:20 
GeneralRe: Single row for multiple results Pin
smcnulty200025-Jul-11 13:04
Membersmcnulty200025-Jul-11 13:04 
AnswerRe: Single row for multiple results Pin
S Douglas11-Aug-11 9:33
professionalS Douglas11-Aug-11 9:33 
QuestionData on one server, structure on another [modified] Pin
_Zorro_22-Jul-11 0:42
professional_Zorro_22-Jul-11 0:42 

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.