Error In Function [message #601955] |
Wed, 27 November 2013 13:44 |
|
Rasol_57
Messages: 18 Registered: November 2012 Location: India
|
Junior Member |
|
|
I wrote this Function
(i used Oracle ODP.NET)
CREATE FUNCTION "MYSCHEMA"."MY_FUNC"(PARAM1 VARCHAR(4000))
RETURNS INT
SPECIFIC SQL110520140321900 BEGIN ATOMIC
DECLARE VAR1 INT;
DECLARE VAR2 INT;
SET VAR1 = NEXTVAL FOR SEQ_TBL_CONTRACTTOEOFFICIAL;
RETURN VAR1;
END
but , The following error appear :
ORA-00921: unexpected end of SQL command
why ?
|
|
|
|
Re: Error In Function [message #601958 is a reply to message #601955] |
Wed, 27 November 2013 14:34 |
John Watson
Messages: 8922 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I think there is an error on every line of your code.
Are you actually trying to write PL/SQL, or is it some other language?
|
|
|