Home » RDBMS Server » Server Administration » Re: calling function from sql
Re: calling function from sql [message #50756] Thu, 04 April 2002 17:10
cl
Messages: 10
Registered: April 2001
Junior Member
I believed instead of END CUBE; it should be END; Then try your select statement again.

FUNCTION CUBE (vCaseNumb IN CHAR)
RETURN NUMBER
IS
vCube NUMBER;
BEGIN
select .... into vCUBE from...where .....;
RETURN vCUBE;
END;
/

Report message to a moderator

Previous Topic: Re: AUTOMATIC OPENING OF ORACLE DATABASE
Next Topic: Do we need to use server for Oracle?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 01:02:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.