Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> select inside function

select inside function

From: abdoul85 <abdoul85_at_gmail.com>
Date: Wed, 17 Oct 2007 06:55:33 -0700
Message-ID: <1192629333.830308.184760@e34g2000pro.googlegroups.com>


create or replace function checkVersion return boolean is   a varchar(1000);
  Res boolean;
begin
  select version into a from v$instance;   if (a like '10%') then
    Res := TRUE;
   else
    begin

     dbms_output.put_line('Skip...');
     Res := FALSE;

    end;
   end if;
  return(Res);
end checkVersion;

It works fine on oracle 8 database, but on 9 and 10 version: LINE/COL ERROR



4/3      PL/SQL: Statement ignored
4/7      PLS-00905: obiekt QGUARADM.CHECKVERSION is incorrect
Received on Wed Oct 17 2007 - 08:55:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US