Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Fetching the data to table
Problem with Fetching the data to table [message #252723] Thu, 19 July 2007 14:59 Go to next message
vamcs
Messages: 20
Registered: June 2007
Location: somerset
Junior Member

This is one of the column in the insert statement which inserts the value to om_flag when i execute the procedure error is too many values
(select third_party_flag from sfa_order_extended soe,sfa_order_booked sob,rep_admin.oe_order_headers_all f
where soe.SFA_ORDER_ID = sob.SFA_ORDER_ID
and f.header_id = sob.OF_HEADER_ID) om_flag
i changed the statement by adding the rowid but after insertion the column om_flag only shows 'N' no value found with status 'Y' (which some order have the status 'Y'(--for reference)
(select third_party_flag from sfa_order_extended soe,sfa_order_booked sob,rep_admin.oe_order_headers_all f
where soe.SFA_ORDER_ID = sob.SFA_ORDER_ID
and f.header_id = sob.OF_HEADER_ID and rownum<2 ) om_flag
what is the issue can any one suggest
Re: Problem with Fetching the data to table [message #252797 is a reply to message #252723] Fri, 20 July 2007 01:01 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Querying XML
Next Topic: Re: mySQL select statement
Goto Forum:
  


Current Time: Thu Dec 08 04:19:04 CST 2016

Total time taken to generate the page: 0.15159 seconds