niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Tools
Error!!!!!
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Wallace
*nix forums beginner


Joined: 19 Apr 2005
Posts: 20

PostPosted: Mon May 15, 2006 11:05 am    Post subject: Re: Error!!!!! Reply with quote

thanx
Back to top
Maxim Demenko
*nix forums Guru


Joined: 24 Apr 2005
Posts: 428

PostPosted: Mon May 15, 2006 9:44 am    Post subject: Re: Error!!!!! Reply with quote

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

PostPosted: Mon May 15, 2006 9:14 am    Post subject: Error!!!!! Reply with 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....
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Wed Jan 07, 2009 10:25 pm | All times are GMT
navigation Forum index » Databases » Oracle » Tools
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Postfix + MySQL error: very strange variable %s iWarior Postfix 0 Mon Aug 25, 2008 2:01 pm
No new posts ** Postfix error on console every minute or so ** ?? drywash Postfix 0 Fri Jul 04, 2008 8:49 pm
No new posts Postfix error bounce diwash Postfix 0 Fri Mar 28, 2008 3:37 am
No new posts I am getting following error in Aix 5.3 rockcharles1 AIX 0 Tue Aug 28, 2007 11:06 pm
No new posts postfix out of memory error - please help metind Postfix 0 Mon Sep 11, 2006 1:54 am

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
[ Time: 0.1822s ][ Queries: 20 (0.1128s) ][ GZIP on - Debug on ]