dbms_sql.column_value syntax

Can anyone tell me why I am receiving the syntax error #307, "too many declarations of 'COLUMN_VALUE' match this call.

Done within Developer 2000

My code.

declare

   b_survey gp_blkhdr.survey_name%TYPE;

begin

   v_cursor := dbms_sql.open_cursor;
   dbms_sql.parse(v_cursor, 1, b_survey, 2);

• Define columns dbms_sql.define_column(v_cursor, 1, b_survey, 20);
• Execute v_ret := dbms_sql.Execute(v_cursor);
• fetch v_ret := dbms_sql.fetch_rows(v_cursor);

   dbms_sql.column_value(v_cursor, 1, b_survey); end;

I can use the same code but with b_value, which is of NUMBER type, and it will work fine. Just get the error when using VARCHAR2 type.

Appreciate any help.

Wes Received on Fri May 01 1998 - 00:00:00 CDT