| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: INSERT using dynamic sql
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
 |
 |