RE: SQL dummy
Date: Fri, 6 Mar 2009 17:51:18 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F8152170A8_at_sunmsx01.Corp.Acxiom.net>
SH*T !!!!!
You got it one buddy. Apologies to everyone out there. My original SQL was fine, I got so wrapped up in that I forgot that the original column on the table was actually build_status and not task_status.
That's it. I am finished for the day. I need a beer.
A virtual one off me to all of you whose time I wasted. Have a good weekend folks.
-----Original Message-----
From: Michael.Coll-Barth_at_VerizonWireless.com
[mailto:Michael.Coll-Barth_at_VerizonWireless.com]
Sent: 06 March 2009 17:47
To: Robertson Lee - lerobe; oracle-l
Subject: RE: SQL dummy
> -----Original Message-----
> From: Robertson Lee - lerobe [mailto:Lee.Robertson_at_acxiom.com]
> Sent: Friday, March 06, 2009 12:45 PM
> To: Coll-Barth, Michael; oracle-l
> Subject: RE: SQL dummy
>
> Yep, tried this as well, its says that task_status is an ivalid
> identifier
Could you send a desc lr_build. That error suggests that the column does not exist in the target table
>
> INSERT INTO lr_build
The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you.
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 06 2009 - 11:51:18 CST