declare
a varchar2(20);
b:=varchar2(20):='gali';
begin
a:=EMP_SEL(b);
dbms_output.put_line(a);
end;
You cannot call the functions like this, only procedures can be.
Venkat
--------- Original Message ---------
DATE: Fri, 06 Jun 2003 03:35:11 From: purushottam krishna hegde <[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Cc:
hi all,this is purushottam hegde from Bangalore(IND)i am relatively new to oracle and so to this group.iam having a problem with function...it goes like this.SQL> CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2) return varchar2 is
2 resex varchar2(3);
3 Begin
4 SELECT sex into resex from emp where name=ename;
5 return(resex);
6 END;
7 /Function created.SQL> EXECUTE EMP_SEL('gali');
BEGIN EMP_SEL('gali'); END;*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: 'EMP_SEL' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignoredpl help me in this regardthanking all of upurushottam hegde
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).
____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
Login To Lycos Mail