Re: Function call

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Wed, 6 Feb 2002 13:59:45 -0800
Message-ID: <a3s8np$8jo$1@spiney.sierra.com>

SQL> create or replace function provafa return number is   2 begin
  3 return(1);
  4 end;
  5 /

Function created.

SQL> variable i number;
SQL> begin

  2            :i:=provafa;
  3            dbms_output.put_line('I= ' || :i);
  4       end;

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
I= 1

PL/SQL procedure successfully completed.

SQL> "Andrea Bertucci" <abertucci_at_aitek.it> wrote in message news:3C6100A9.24892A1A_at_aitek.it...
> Hi,
> i'm developing under linux.
> I'm using unixODBC and ODBC oracle driver.
> I've wrote a simple store function: "
> create or replace function provaFA return number is
> begin
> return(1);
> end provaFA;
> "
>
> How I can call it and obtain result value?
> Thanks,
> Andrea.
>
Received on Wed Feb 06 2002 - 15:59:45 CST