Re: select inside function

On 17 oct, 15:55, abdoul85 <abdou..._at_gmail.com> wrote:
> 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

Grants on v$instance granted through a role?

Cheers.

Carlos. Received on Wed Oct 17 2007 - 09:27:14 CDT