[SQL] writing a dynamic sql

[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,     description,     category_id,     priority_id,     activity_start_time,     activity_end_time, )  VALUES   (     NEXTVAL(\'seq_activities\'),     rec_recurrence.activity_id,     rec_activity.activity_type_id,     rec_activity.subject,     rec_activity.description,     rec_activity.category_id,     rec_activity.priority_id,     rec_activity.activity_start_time,     rec_activity.activity_end_time );';   execute v_sql; I got an error saying that the record variable which I declared earlier is not having reference (or it does not exists). Any suggestion to pack this inside a dynamic function and call it inside many if conditions. Pls shed some light. Regards kumar