Subject | Execute Statement problem with timestamp |
---|---|
Author | Olaf Kluge |
Post date | 2011-11-23T23:18:48Z |
Hello,
I've a little problem with a sql statement:
s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende)
values ('
|| :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ','
|| '1111' || ',' || '2222' || ')';
execute statement s_stmmain;
t_timestamp is a timestamp value and has a blank character. Now, I have test
it with quotest '''', but it does not work.
Has anyone an idea?
Thank you.
Best regards
Olaf
[Non-text portions of this message have been removed]
I've a little problem with a sql statement:
s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende)
values ('
|| :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ','
|| '1111' || ',' || '2222' || ')';
execute statement s_stmmain;
t_timestamp is a timestamp value and has a blank character. Now, I have test
it with quotest '''', but it does not work.
Has anyone an idea?
Thank you.
Best regards
Olaf
[Non-text portions of this message have been removed]