Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> select inside function
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;
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 incorrectReceived on Wed Oct 17 2007 - 08:55:33 CDT
![]() |
![]() |