pl/sql syntax

[YYYYUU]

Can anyone tell me what is wrong with the syntax I've used. The error comes up where marked *******

DECLARE

CURSOR f_merge_data is

SELECT ftc_merge_field_id, mf_merge_field_tag, mf_merge_prompt

FROM free_text_control, merge_fields

WHERE ftc_doc_id = '30' AND ftc_merge_field_id = mf_merge_field_id ;

CURSOR cura(pID free_text_results.ftc_merge_field_id) IS

SELECT ftiv_min_input_length, ftiv_max_input_length, ftiv_validation

FROM free_text_input_validation

WHERE ftiv_merge_field_id = pID recdata cura%ROWTYPE; *************errors on this line

BEGIN

FOR free_text_results in f_merge_data LOOP

OPEN cura(free_text_results.ftc_merge_field_id);

FETCH cura INTO recdata;

CLOSE cura;

END LOOP;

END;

I just need to know if there is a simply syntax problem.

Thanks

 

[lewisp]

You've missed the ; after your cursor declaration

[tt]DECLARE
CURSOR f_merge_data is
SELECT ftc_merge_field_id, mf_merge_field_tag, mf_merge_prompt
FROM free_text_control, merge_fields
WHERE ftc_doc_id = '30' AND ftc_merge_field_id = mf_merge_field_id ;

CURSOR cura(pID free_text_results.ftc_merge_field_id) IS
SELECT ftiv_min_input_length, ftiv_max_input_length, ftiv_validation
FROM free_text_input_validation
WHERE ftiv_merge_field_id = pID;
recdata cura%ROWTYPE;
BEGIN
FOR free_text_results in f_merge_data LOOP
OPEN cura(free_text_results.ftc_merge_field_id);
FETCH cura INTO recdata;
CLOSE cura;
END LOOP;
END;[/tt]