Re: dbms_sql.column_value overload error with varchar2 out

winters_at_tweety.sna.com (Brad Winters) wrote:

> :
>
>
> 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.
>

I had the exact same problem. Never received a reply that I found satisfactory. Converted to Forms_DDL... Curious to see if you have more luck than I did.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Tue Jan 23 1996 - 00:00:00 CET