Re: dbms_sql.column_value overload error with varchar2 out

Hello;

Oracle7 Server Documentation Addendum release 7.1, page 7-9

  "The following syntax is also supported for the column_value procedure:

    procedure column_value_char"

note the "_char" in the name. Use that procedure for varchar2, not column_value.

In article <31054856.1861188_at_news.brookings.net> kasten_at_brookings.net (Chris Kasten) writes:

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

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 Feb 03 1996 - 00:00:00 CET