Home » RDBMS Server » Server Administration » calling function from sql
calling function from sql [message #50752] Thu, 04 April 2002 12:46 Go to next message
Eugene
Messages: 44
Registered: August 2001
Member
Hi all,
I have function with the following syntax:

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

I am getting an error message when I am trying to to the following:
select cube('1234') from dual
What am I doing wrong???

Thanks,
Eugene

Report message to a moderator

Re: calling function from sql [message #50753 is a reply to message #50752] Thu, 04 April 2002 12:59 Go to previous message
saleem
Messages: 65
Registered: January 2002
Member
what might that error message be?

Report message to a moderator

Previous Topic: Re: certification guide -8/8i/9i
Next Topic: Re: error sp2-0575
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:32:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.