|
|
|
|
|
|
| Author |
Message |
Wallace *nix forums beginner
Joined: 19 Apr 2005
Posts: 20
|
Posted: Mon May 15, 2006 11:05 am Post subject:
Re: Error!!!!!
|
|
|
|
thanx |
|
| Back to top |
|
 |
Maxim Demenko *nix forums Guru
Joined: 24 Apr 2005
Posts: 428
|
Posted: Mon May 15, 2006 9:44 am Post subject:
Re: Error!!!!!
|
|
|
Wallace schrieb:
| Quote: | Hai All,
I am having a function as follows...
CREATE OR REPLACE FUNCTION UDTRAEKJOB.FUNC_COSA_FORMAL(vUDTREK_ID
NUMBER(14,0), vSTARTDATO DATE, vSLUTDATO DATE)
RETURN INTEGER AS
TYPE COSA_FORMAL_LISTTYPE IS TABLE OF XPRS$COSA_FORMAL_V%ROWTYPE;
BEGIN
...............
END;
While compiling, I am getting an error as "Error(1,55): PLS-00103:
Encountered the symbol "(" when expecting one of the following: :=
.. ) , @ % default character The symbol ":=" was substituted for "(" to
continue."
Kindly help!!!!
Looking forward for the response....
|
In the argument list you don't specify data length/precision, only the
type ( i.e. vUDTREK_ID NUMBER,vSTARTDATO DATE,...)
Best regards
Maxim |
|
| Back to top |
|
 |
Wallace *nix forums beginner
Joined: 19 Apr 2005
Posts: 20
|
Posted: Mon May 15, 2006 9:14 am Post subject:
Error!!!!!
|
|
|
Hai All,
I am having a function as follows...
CREATE OR REPLACE FUNCTION UDTRAEKJOB.FUNC_COSA_FORMAL(vUDTREK_ID
NUMBER(14,0), vSTARTDATO DATE, vSLUTDATO DATE)
RETURN INTEGER AS
TYPE COSA_FORMAL_LISTTYPE IS TABLE OF XPRS$COSA_FORMAL_V%ROWTYPE;
BEGIN
...............
END;
While compiling, I am getting an error as "Error(1,55): PLS-00103:
Encountered the symbol "(" when expecting one of the following: :=
.. ) , @ % default character The symbol ":=" was substituted for "(" to
continue."
Kindly help!!!!
Looking forward for the response.... |
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|
|
The time now is Wed Jan 07, 2009 10:25 pm | All times are GMT
|
|
Debt Help | Credit Cards | Loans | Debt Consolidation | Watch Anime Online
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|