Re: INSERT using dynamic sql

From: Ortwin Glück <glueck_at_freesurf.ch>
Date: Fri, 08 Sep 2000 21:52:37 +0200
Message-ID: <39B94385.CBA312E6@freesurf.ch>

What you do:
INSERT INTO mytable VALUES (myfield1, myfield2)

What you SHOULD do:
INSERT INTO mytable (myfield1, myfield2) VALUES (myvalue1, myvalue2)

Regards

O. Glueck

Mac wrote:
>
> Hi there,
>
> I'm trying to use dynamic SQL to insert some data in a table
> that could be different every time, in a Pro*C program. I'm
> coding on Unix and accessing to an Oracle 8 db. Here's what I do
> (a bit long):
>
> sprintf(sqlText, "INSERT into %s VALUES
> (:cdrCurRec.tccs_seq_id,:cdrCurRec.zip_file_name_id:cdrCurRec.ama_file_n

                                                    ^^^
-----------------------------------------------------+

maybe the problem is here?

> ame_id,:cdrCurRec.cdrv_asc_file_name_id,:cdrCurRec.cdrv_bin_file_name_id
> ,:cdrCurRec.gmt_load_dt_time,:cdrCurRec.gmt_prcss_dt_time,:cdrCurRec.ser
> v_type,:cdrCurRec.rject_reasn,:cdrCurRec.dup_orgin_seq_id,:cdrCurRec.rje
> ct_actn_cd,:cdrCurRec.rject_reprcss_flag,:cdrCurRec.call_id,:cdrCurRec
> .swtch_seq_id,:cdrCurRec.orgin_line_dig,:cdrCurRec.cic,:cdrCurRec.auth_c
> d_swtch_trunk,:cdrCurRec.callg_no,:cdrCurRec.acct_cd,:cdrCurRec.call_typ
> e,:cdrCurRec.bill_type,", tableName);
>
> sprintf(buffer,":cdrCurRec.trnsl_no,:cdrCurRec.orgin_trunk_grp,:cdrCurRe
> c.term_trunk_grp,:cdrCurRec.bill_no,:cdrCurRec.orgin_dt,:cdrCurRec.dur,:
> cdrCurRec.orgin_time,:cdrCurRec.pay_phone_ind,:cdrCurRec.cntry_cd,:cdrCu
> rRec.ldwc_fl,:cdrCurRec.div_cd_fl,:cdrCurRec.swtch_2_char,:cdrCurRec.fil
> e_name,:cdrCurRec.osda_fl,:cdrCurRec.term_swtch,:cdrCurRec.final_term_tr
> unk_grp,:cdrCurRec.re_orgin_fl,:cdrCurRec.filler)");
> strcat(sqlText,buffer);

>[...] Received on Fri Sep 08 2000 - 14:52:37 CDT