0 - 4 of 4 tags for syntax error 3707

I have 3 prompts in my report: (1) Group Number, (2) State, and (3) Branches. The user selects the group number (1) and the prompt for State (2) is updated with all of the states the group does business in. Then the user selects either "null" or one of the states from the state prompt (2).

replace procedure myprocess(in p_date date)

 

Begin

 

insert into my_table(field_1,field_2)

 

with tmp_tab(field1,field2,field3) as

 

(select field1,field2,field3

 

    From my_table2)

 

select field1,field2

 

replace procedure myprocess(in p_date date)

 

Begin

 

insert into my_table(field_1,field_2)

 

with tmp_tab(field1,field2,field3) as

 

(select field1,field2,field3

 

    From my_table2)

 

select field1,field2

 

replace procedure myprocess(in p_date date)

 

Begin

 

insert into my_table(field_1,field_2)

 

with tmp_tab(field1,field2,field3) as

 

(select field1,field2,field3

 

    From my_table2)

 

select field1,field2