Re: [SQL] writing a dynamic sql

2004-02-15 Thread Tomasz Myrta
Dnia 2004-02-10 10:48, Użytkownik Senthil Kumar S napisał: Dear friends, I am having an lengthy SQL, which will be called every conditions of if...else statement. I tried with passing that via a string and execute it. But I got error. v_sql := 'INSERT INTO activities( activity_id, paren

[SQL] writing a dynamic sql

2004-02-15 Thread Senthil Kumar S
Dear friends,I am having an lengthy SQL, which will be called every conditions of if...else statement. I tried with passing that via a string and execute it.But I got error. v_sql :=  'INSERT INTO activities(    activity_id,    parent_activity_id,    activity_type_id,    subject,    descrip