dbms_sql.column_value overload error with varchar2 out

:

I'm able to create dynamic sql select lists but can only compile and run those for integer values. The compiler complains about a call to the overloaded function

dbms_sql.column_value(cursor_handle,pos_in_select,return_value);

if return value is an integer or number, it all works great!!

if return_value is a date or varchar2, the compiler balks (error 307) the one where overloaded functions appear the same.

As far as I know, I have used the define_column's as required. Varchars have the extra size value.

I used the example in Steve Fuersteins PL/SQL ant book in which forms is calling the dbms_sql builtins to populate form variables.

Any help appreciated. Thanks in advance!

        Brad Winters Received on Tue Jan 23 1996 - 00:00:00 CET