Re: DBMS_SQL function call

Søren M. Olesen wrote:
>
> Hi
>
> How do I call a function and getting the return value using dbms_sql ??
>
> Thanks
>
> Soren M. Olesen
>
> N.B. I need to get it to work from forms

  cur := dbms_sql.open_cursor;
  dbms_sql.parse(cur, 'begin :var := yourfunc(); end;',

         dbms_sql.v7);
  dummy := dbms_sql.execute(cur);
  dbms_sql.column_value(cur, ':var', ....);   dbms_sql.close_cursor(cur);

-- 

                    ____________________________________________ 
                   /    Kenichi Mizuta 
                  /     Oracle Corporation (Redwood Shores, CA) 
       ////      /      Applications Division 
      |0 0|     /       email: kmizuta_at_us.oracle.com 
 _ooO_ \U/_Ooo_/        url: http://members.tripod.com/~kmizuta/

 The comments and opinions expressed herein are mine and
 do not necessarily represent those of Oracle Corporation.