OraFAQ Forum: SQL & PL/SQL » FUNCTION COMPLIATION ERROR

Home » SQL & PL/SQL » SQL & PL/SQL » FUNCTION COMPLIATION ERROR

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FUNCTION COMPLIATION ERROR [message #597738]

Tue, 08 October 2013 00:50

IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae

Junior Member

Hai Everyone

I have written the following function,But it showing compilation errors.Please help me whats the error.
CREATE OR REPLACE FUNCTION F_GRN_NUM (ITEMCODE VARCHAR2)
RETURN NUMBER
AS
V_GRN NUMBER;
BEGIN
SELECT GH_NO INTO V_GRN
FROM OT_GR_ITEM
RETURN (V_GRN);
ECXEPTION WHEN OTHERS
THEN RETURN 0;
END F_GRN_NUM;

Report message to a moderator

Re: FUNCTION COMPLIATION ERROR [message #597739 is a reply to message #597738]

Tue, 08 October 2013 01:12

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And we are supposed to know what is your error?
Maybe "ECXEPTION" has the same error than "COMPLIATION".

[Updated on: Tue, 08 October 2013 01:12]

Report message to a moderator

Re: FUNCTION COMPLIATION ERROR [message #597744 is a reply to message #597738]

Tue, 08 October 2013 03:26

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Hi Irfan. You've posted a few questions now. And in each of those questions, people have given up their time for free to offer you advice. Up until now, you have posted no acknowledgment of their efforts. It is considered a general forum courtesy to post such an acknowledgement (to, for example, say whether the information you received was useful/successful or not)

Cheers

Report message to a moderator

Previous Topic:	Queue table - error
Next Topic:	CREATE TABLE ... DEFAULT TABLESPACE FOR COLUMNS ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:34:16 CDT 2024