Re: dbms_sql.column_value overload error with varchar2 out

Greetings;

In article <4e375s$8t7_at_tweety.sna.com> winters_at_tweety.sna.com (Brad Winters) writes:>Path:

>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!!

Well, it's to early on a Saturday to dig the manual out, so this is from memory. your problem is (I believe) that you have to use the function

  dbms_sql.column_value_char

notice the _char part on the end. this function is for, obviously, char type data, and it takes different parameters than the one you're using, which is for numeric data. the other functions are defined in the book right after the one you're using. hope my memory hasn't gone to hell..

David J. DeWolfe
Data Base Specialist
Statewide Office of Information Services University of Alaska
sxdjd_at_orca.alaska.edu

In a vicious struggle for survival intelligence emerges as the weapon of  choice. - Nova, In Search of Human Origins                    Received on Sat Jan 27 1996 - 00:00:00 CET