Dynamic SQL error [message #10610] |
Tue, 03 February 2004 07:44 |
scion
Messages: 4 Registered: February 2004
|
Junior Member |
|
|
v_tmp_str := 'SELECT '||
'LTRIM(RTRIM(TO_CHAR(SYSDATE, ''YYYYMMDDHH24MISS''))) || LTRIM(RTRIM(TO_CHAR(event_id_seq.NEXTVAL, ''09999''))) AS v_event_id, ' ||
'''' || v_del_status || ''', '||
'''' || v_apprv_status || ''', '||
'f_meas, '||
't_meas, '||
'eoffset, '||
'duu_id, '||
'rch_code, '||
'rch_date, '||
'''' || p_new_attr_prg || ''', '||
'''' || v_attr_val || ''', '||
'''' || p_new_entity_id || ''', '||
'state, '||
'meters, '||
'''' || p_l_meta_id || ''', '||
'rid, '||
'objectid_seq.NEXTVAL, '||
'''' || p_user_id || ''', '||
'SYSDATE, '||
'''' || p_org_id || ''' '||
'FROM ''' || v_from_table || '''' ||
'WHERE entity_id = ''' || p_rad_entity_id ||'''';
v_sql_str := 'INSERT INTO '|| v_table ||' values (''' || v_tmp_str || ''');';
dbms_output.put_line(v_sql_str);
EXECUTE IMMEDIATE v_sql_str;
The above code gives me an error...and i've tried tried and tried but havent figured it out.
|
|
|
|