Re: Multitable Insert Problem

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:4514d249$0$20242$636a55ce_at_news.free.fr...
>
>
> Avoid blank lines in SQL*Plus; its meaning is "abort the current statement
entry":
>
> SQL> INSERT ALL
> 2
> SQL> INTO hmp_well_visits VALUES ( person_id )
> SP2-0734: unknown command beginning "INTO hmp_w..." - rest of line
ignored.
> SQL>
> SQL>
> SQL> INTO hmp_well_visits VALUES ( person_id )
> SP2-0734: unknown command beginning "INTO hmp_w..." - rest of line
ignored.
> SQL>
> SQL>
> SQL> SELECT DISTINCT a.person_id AS person_id,
> 2 a.mbr_key AS mbr_key,
> 3 a.mbr_sys_key AS mbr_sys_key,
> 4 a.clm_id AS clm_id,
> 5 a.clm_line_nbr AS clm_line_mbr,
> 6 a.clmdtl_key AS clmdtl_key,
> 7 a.srv_dt_from AS srv_dt_from,
> 8 a.cpt_hcpcs AS cpt_hcpcs,
> 9 a.proc_i_1 AS proc_i_1,
> 10 a.dtl_diag AS dtl_diag,
> 11 a.srv_prv_id AS srv_prv_id,
> 12 a.clm_src AS clm_src,
> 13 a.hcfa_pos AS hcfa_pos,
> 14 'WV' AS hmp_disease_code,
> 15 '1' AS data_source
> 16 FROM hb_hmp_vclaim a
> 17 WHERE a.srv_dt_from >= TO_DATE('&1','MMDDYYYY')
> 18 AND a.person_id > 0;
> FROM hb_hmp_vclaim a
> *
> ERROR at line 16:
> ORA-00942: table or view does not exist
>
> Regards
> Michel Cadot
>
>

Thanks. Since I could see nothing syntactically wrong that has to be what was happening. Thanks again. Received on Sun Sep 24 2006 - 21:39:21 CDT