OraFAQ Forum: SQL & PL/SQL » syntax error

Home » SQL & PL/SQL » SQL & PL/SQL » syntax error

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

syntax error [message #462112]

Tue, 22 June 2010 14:45

A1A2A3A4
Messages: 1
Registered: June 2010
Location: HYDERABAD

Junior Member

i got some error at end plsql program them it shows ; is unexpected at if

Report message to a moderator

Re: Pass Date parameter [message #462116 is a reply to message #462112]

Tue, 22 June 2010 14:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i got some error at end plsql program them it shows ; is unexpected at if
ERROR? What Error? I don't see any error.

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

Report message to a moderator

Re: Pass Date parameter [message #462136 is a reply to message #462116]

Tue, 22 June 2010 23:38

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

Senior Member
Account Moderator

So put a ; at IF.

Regards
Michel

[Updated on: Wed, 23 June 2010 00:47]

Report message to a moderator

Re: syntax error [message #462142 is a reply to message #462112]

Wed, 23 June 2010 00:46

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Following is the solution of your problem...

Write ERROR-FREE pl/sql program. Cool

Cool

regards,
Delna

Report message to a moderator

Re: syntax error [message #462155 is a reply to message #462142]

Wed, 23 June 2010 01:26

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

So put a ; at IF.

/forum/fa/449/0/

sriram

[Updated on: Wed, 23 June 2010 01:29]

Report message to a moderator

Re: syntax error [message #462156 is a reply to message #462155]

Wed, 23 June 2010 01:27

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Very Happy

Report message to a moderator

Re: syntax error [message #462366 is a reply to message #462156]

Wed, 23 June 2010 13:21

Bill B
Messages: 1971
Registered: December 2004

Senior Member

If you type show errors after error is reported, it will show you the line the error was reported on.

Report message to a moderator

Previous Topic:	Declaring arrays inside stored procedure
Next Topic:	select records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 19:54:01 CDT 2024