Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Script to Disable Constraint, Change Value, then Enable Const

RE: Script to Disable Constraint, Change Value, then Enable Const

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Wed, 28 Nov 2001 15:29:03 -0800
Message-ID: <F001.003CFA54.20011128134022@fatcity.com>

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>I know it looks like a semi-colon error, but it&#8217;s not.<span style="mso-spacerun: yes">  Please send me one of your examples that you know works and I&#8217;ll modify and try here.

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; font-style:italic'>Database Administrator<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue;mso-color-alt:windowtext;font-style:italic'>

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext;font-weight:bold'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>4815 Emperor Blvd., Suite 110<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Durham, NC 27703<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Tel. (919) 941-4645<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Fax (919) 474-0735<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Email <a href="mailto:dwagoner_at_arsenaldigital.com"><span style='font-family:"Times New Roman"'>mailto:dwagoner_at_arsenaldigital.com<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Web <a href="http://www.arsenaldigital.com/"><span style='font-family:"Times New Roman"'>http://www.arsenaldigital.com/<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'> <font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'><span style="mso-spacerun:

yes">                                                                                                         

<span style='font-size:

8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>***<span style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun: yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.  If you have
received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer.  Thank you.<font
size=1 color=blue face=Arial><span style='font-size:8.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
class=EmailStyle23><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<font size=2 color=black

face=Tahoma>-----Original
Message-----
From: Cale, Rick T (Richard)
[mailto:RICHARD.T.CALE_at_saic.com]
Sent: Wednesday, November 28, 2001
2:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>David,<font color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>You need a semi-colon after line2 i.e., update table1 ...;<span style='color:black;mso-color-alt:windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Rick<font color=black>

<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:1.0in'><span style='font-size: 10.0pt;font-family:Tahoma;color:black'>-----Original Message----- From: David Wagoner
[mailto:dwagoner_at_arsenaldigital.com]
Sent: Wednesday, November 28, 2001
1:16 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const<span style='color:black;mso-color-alt:windowtext'>

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>Rick, thanks for your input.<span style="mso-spacerun: yes">  When I test the deferred constraint in SQL*Plus I get an error.  What am I
doing wrong?  I did not find much
information in the docs about deferred constraints.

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>  SQL>
set constraints all deferred

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'><span style="mso-spacerun: yes">        2<span
style="mso-spacerun: yes">  update table1 set host_name = 'tigerz' where host_name = 'tiger'

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'><span style="mso-spacerun: yes">        3* update table2 set
host_name = 'tigerz' where host_name = 'tiger';

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>SQL>

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>update host set host_name = 'tigerz' where host_name = 'tiger'

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>*

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>ERROR at line 2:

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>ORA-00933: SQL command not properly ended

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>TIA,

<font

size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<!---size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element: field-begin'> AUTOTEXTLIST
\s "E-mail Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue;font-style:italic'>Database Administrator<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue;font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-weight:bold'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>4815 Emperor Blvd., Suite 110<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>Durham, NC 27703<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>Tel. (919) 941-4645<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>Fax (919) 474-0735<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>Email <font
face="Times New Roman">mailto:dwagoner_at_arsenaldigital.com<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>Web <font
face="Times New Roman">http://www.arsenaldigital.com/<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'> <span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black; mso-color-alt:windowtext'>

<font size=2 color=blue

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'><span style="mso-spacerun:

yes">                                                                                                         

<span style='font-size:

8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>***<span style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun: yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black; mso-color-alt:windowtext'>

<font size=1 color=blue

face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:blue'>This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.<span style="mso-spacerun: yes">  If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer.<span style="mso-spacerun: yes">  Thank you.<font size=1 color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<!---size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element: field-end'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<font size=2 color=black

face=Tahoma>-----Original
Message-----
From: Cale, Rick T (Richard)
[mailto:RICHARD.T.CALE_at_saic.com]
Sent: Wednesday, November 28, 2001
12:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const<span style='color:black;mso-color-alt:windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=2 color=blue

face=Arial>I have
had the same type of requirement and decided to use deferrable constraints. <font color=black>

<font size=2 color=blue

face=Arial>Works
great!<span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=2 color=blue

face=Arial>Rick<font
color=black>

<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:2.0in'><span style='font-size: 10.0pt;font-family:Tahoma;color:black'>-----Original Message----- From: Igor Neyman
[mailto:ineyman_at_perceptron.com]
Sent: Wednesday, November 28, 2001
11:56 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Script to Disable
Constraint, Change Value, then Enable Const<span style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:10.0pt;color:black'>Not good approach.<font color=black>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:10.0pt;color:black'>Instead, use 'deferrable constraints, should work in your situation.<span
style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:12.0pt;color:black'> <span style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:2.0in'><span
style='font-size:12.0pt;color:black'>Igor Neyman, OCP DBA ineyman_at_perceptron.com
  <span style='color:black;mso-color-alt: windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial>-----
Original Message ----- <span
style='font-size:10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding: 0in;mso-padding-alt:0in 0in 0in 4.0pt'><span style='font-size:10.0pt;font-family:Arial;color:black;font-weight:bold'>

From:<font size=2 color=black
face=Arial> <a
href="mailto:dwagoner_at_arsenaldigital.com" title="dwagoner_at_arsenaldigital.com">David Wagoner

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding: 0in;mso-padding-alt:0in 0in 0in 4.0pt'><span style='font-size:10.0pt;font-family:Arial;color:black'> <font size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black; font-weight:bold'>To:<span
style='font-size:10.0pt;font-family:Arial;color:black'> <a href="mailto:ORACLE-L_at_fatcity.com" title="ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L <font size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black; mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black; font-weight:bold'>Sent:<span
style='font-size:10.0pt;font-family:Arial;color:black'> Wednesday, November 28, 2001 11:24 AM<span
style='font-size:10.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black; font-weight:bold'>Subject:<font size=2 color=black face=Arial> RE:
Script to Disable Constraint, Change Value, then Enable Const<font size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:147.75pt;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3 color=black face="Times New Roman"> <font
color=black>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>I can see the confusion here.  The point is not
to let someone enter data<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>that would violate the referential integrity.  Let me
explain with an<span
style='font-size:10.0pt;font-family:"Courier New";color:black;mso-color-alt: windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>example:<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><span style="mso-spacerun: yes"> <font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black'>1.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>User wants to update a primary key record in parent table<span
style='font-size:10.0pt;font-family:"Courier New";color:black;mso-color-alt: windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black'>2.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>Dependent data exists in a child table so the user gets an error while trying to perform step 1<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black'>3.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>It is necessary to disable the FK constraint in order to update both tables<span
style='font-size:10.0pt;font-family:"Courier New";color:black;mso-color-alt: windowtext'>

<p class=MsoNormal style='margin-left:189.75pt;text-indent:-24.0pt;tab-stops:
list 42.0pt;mso-layout-grid-align:none;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black'>4.<span style='font-size:
7.0pt;color:black'>        <font
size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>Enable the FK constraint successfully<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><span style="mso-spacerun: yes"> <font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'><span style="mso-spacerun: yes"> <font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>Does that make sense?  This is a process we have
to do routinely and it has<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>happened in the past that the FK was mistakenly not re-enabled, which<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;mso-layout-grid-align:none;
border:none;mso-border-left-alt:solid black 1.5pt;padding:0in;mso-padding-alt: 0in 0in 0in 4.0pt'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>allowed "illegal" data to be loaded later.<span style="mso-spacerun: yes">  Thus the need for a script.<font size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle20><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle20><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><!---size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element: field-begin'> AUTOTEXTLIST
\s "E-mail Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;font-style:italic'>Database Administrator<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black; mso-color-alt:windowtext;font-weight:bold'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>4815 Emperor Blvd., Suite 110<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>Durham, NC 27703<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>Tel. (919) 941-4645<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>Fax (919) 474-0735<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>Email <font face="Times New Roman">mailto:dwagoner_at_arsenaldigital.com<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>Web <font
face="Times New Roman">http://www.arsenaldigital.com/<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'> <font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'><span style="mso-spacerun:

yes">                                                                                                         

<span style='font-size:

8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>***<span style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun: yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black; mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=1 color=blue face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue'>This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.<span style="mso-spacerun: yes">  If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer.<span style="mso-spacerun: yes">  Thank you.<font size=1 color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:147.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><!---size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element: field-end'><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma; color:black'>-----Original Message-----
From: Mark Leith
[mailto:mark_at_cool-tools.co.uk]
Sent: Wednesday, November 28, 2001
5:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Constrain<span style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3 color=black face="Times New Roman"> <font color=black>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial; color:blue'>How could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards?<span style='color:black; mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3 color=black face="Times New Roman"> <font color=black>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial; color:blue'>Not a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail.. <span style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=3 color=black face="Times New Roman"> <font color=black>

<p class=MsoNormal style='margin-left:183.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial; color:blue'>I struggle to see why you would want to do this - do you have any more info?<span style='color:black;mso-color-alt: windowtext'>

<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;
margin-left:219.75pt;border:none;mso-border-left-alt:solid black 1.5pt; padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Tahoma>-----Original
Message-----
From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of David Wagoner
Sent: 27 November 2001 21:30
To: Multiple recipients of list
ORACLE-L
Subject: Script to Disable Constraint,
Change Value, then Enable Constrain<span style='color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Listers,

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Does anyone have a script that will do the following:

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>1.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Accept user input for old data value<font color=black> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>2.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Accept user input for new data value<font color=black> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>3.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Disable table constraint<span
style='color:black'> <font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>4.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Update record with new data value<span style='color:black'> <font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>

<p class=MsoNormal style='margin-left:255.75pt;text-indent:-.25in;tab-stops:
list 1.0in;border:none;mso-border-left-alt:solid black 1.5pt;padding:0in; mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>5.<font
size=1 color=black><span style='font-size:7.0pt;mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"'>      
<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Enable constraint<span
style='color:black'> <font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial'>

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>A script like this would help ensure that constraints are not left "off" after updates, allowing "illegal" data into the tables.<span style="mso-spacerun: yes">  Good user-proof script I would think.

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>TIA,

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>david

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span class=EmailStyle19><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;font-style:italic'>Database Administrator<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:black;mso-color-alt:windowtext;font-weight:bold'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>4815 Emperor Blvd., Suite 110<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>Durham, NC 27703<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>Tel. (919) 941-4645<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>Fax (919) 474-0735<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>Email <a
href="mailto:dwagoner_at_arsenaldigital.com"><span style='font-family:"Times New Roman"'>mailto:dwagoner_at_arsenaldigital.com<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>Web <font face="Times New Roman">http://www.arsenaldigital.com/<font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'> <font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'><span style="mso-spacerun:

yes">                                                                                                         

<span

style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>***<span style="mso-spacerun: yes">  NOTICE<span style="mso-spacerun: yes">  ***<span
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black; mso-color-alt:windowtext'>

<p class=MsoAutoSig style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font size=1 color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black'>This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.<span style="mso-spacerun: yes">  If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer.<span style="mso-spacerun: yes">  Thank you.<font size=1 color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:black;mso-color-alt:windowtext'>

<p class=MsoNormal style='margin-left:219.75pt;border:none;mso-border-left-alt:
solid black 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font color=black> <span
style='color:black;mso-color-alt:windowtext'> Received on Wed Nov 28 2001 - 17:29:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US