Posted by tmort Fri 2nd Mar 2007 00:21 - Syntax is Oracle 8 - 24 views
Download | New Post | Modify | Hide line numbers
Description:
incorrect number of values

  1. INSERT INTO fv_document
  2.             (doc_id, doc_url_id, doc_class_id, doc_type_id, user_id,
  3.             doc_status_id, doc_title, doc_desc, date_created, date_updated,
  4.             map_lat, map_lon, bldg_floor
  5.             )
  6.      VALUES ((SELECT doc_id, doc_url_id, doc_class_id, doc_type_id, user_id,
  7.                      1, doc_title, doc_desc, SYSDATE, NULL,
  8.                       map_lat, map_lon, 1 FROM fv_document2)
  9.             )

PermaLink to this entry https://pastebin.co.uk/11269
Posted by tmort Fri 2nd Mar 2007 00:21 - Syntax is Oracle 8 - 24 views
Download | New Post | Modify | Hide line numbers

 

Comments: 0