C#

(Period > 9 AND Year > 2007) AND (Period < 5 AND Year < 2008)

I are troll

string strSEQ = 
@"DECLARE
N NUMBER(10);
BEGIN
    SELECT MAX(ID)+1 INTO N FROM "+ strTableName +@";
-- CREATING SEQUENCE
Execute immediate ('DROP SEQUENCE SEQ_TEMP');
Execute immediate ('CREATE SEQUENCE SEQ_TEMP
    MINVALUE 1
    START WITH '||N||'
    INCREMENT BY 1
    CACHE 20
    ORDER');
END;
/
";

                
                //Writing a script file and executing it
                string strTempFile = Environment.GetEnvironmentVariable("TEMP")+"\\tmp_SCRIPT.SQL";
                string CR = "\r\n";

                System.IO.StreamWriter sw;

                System.Diagnostics.Process p = new System.Diagnostics.Process();
                p.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
                p.StartInfo.CreateNoWindow = true;
                p.EnableRaisingEvents = true;
                p.Exited += new System.EventHandler(p_Exited);

                p.StartInfo.FileName = @"SQLPLUS.exe";
                

                //Writing Script File
                sw = new System.IO.StreamWriter(strTempFile);
                sw.Write(strSEQ);
                sw.Flush();
                sw.Close();

                p.StartInfo.Arguments = @"USERNAME/PASSWORD @" + strTempFile + "  >> " + 
                strTempFile.Replace(".sql",".log");
                p.Start();
            }

            private void p_Exited(object sender, EventArgs e)
            {
                MessageBox.Show("Done");
            }

Pete O'Hanlon wrote:

the only other one I can think of is an OutOfMemoryException.

<br />
try {<br />
   IPerson oPerson = ISession.Get(....);<br />
   ...<br />
   oSomeProperty = LoadProperty(...);    // still okay!! Successfully loaded oSomeProperty and it is not NULL or invalid.<br />
<br />
   oPersom.SomeProperty = null; // Okay!!<br />
   oPerson.SomeProperty = new PersonProperty(...); // Okay!!<br />
   oPerson.SomeProperty = oSomeProperty; // ** crash!!!  oPerson NOT NULL!!<br />
<br />
<br />
} catch(Exception ex)<br />
{<br />
  Console.WriteLine("Tell me everything..."); Exception? try-catch never caught it?!<br />
}<br />
<br />
class Person<br />
{<br />
   protected PersonProperty _SomeProperty = null;<br />
   ...<br />
   public PersonProperty SomeProperty<br />
   { <br />
       get { return _SomeProperty; }<br />
       set {<br />
         _SomeProperty = value; << Actually it crashed right here.<br />
       }<br />
   }<br />
   ...<br />
}<br />