RE: SQL dummy
- From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
- To: <Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Mar 2009 17:51:18 -0000
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@xxxxxxxxxxxxxxxxxxx
[mailto:Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx]
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@xxxxxxxxxx]
> 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.
****************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
