RE: procedure/function error

[Santosh Varma]

function cannot be called with EXEC. u have to call it within a procedure...

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of purushottam krishna hegde
Sent: Friday, June 06, 2003 5:05 PM
To: Multiple recipients of list ORACLE-L
Subject: procedure/function error

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 ignored

 

 

 

pl help me in this regard

 

thanking all of u

 

purushottam hegde

 

 

---

Do you Yahoo!?
Free online calendar with sync to Outlook(TM).