OraFAQ Forum: SQL & PL/SQL » ORA-01003: no statement parsed

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01003: no statement parsed

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

ORA-01003: no statement parsed [message #616637]

Thu, 19 June 2014 04:16

sss111ind
Messages: 634
Registered: April 2012
Location: India

Senior Member

I am getting the same error in a merge statement accessing through the db link.Please suggest.

[Split from an ancient topic by LF]

[Updated on: Thu, 19 June 2014 04:23] by Moderator

Report message to a moderator

Re: ORA-01003: no statement parsed on CREATE TABLE [message #616638 is a reply to message #616637]

Thu, 19 June 2014 04:23

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Post the complete statement and complete error message.

Report message to a moderator

Re: ORA-01003: no statement parsed [message #616639 is a reply to message #616637]

Thu, 19 June 2014 04:25

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forums's wizards are on a coffee break; wait until they return (along with their crystal balls) so that they could suggest something. I have difficulties in debugging code I can't see (what a drawback, eh?).

Report message to a moderator

Re: ORA-01003: no statement parsed [message #616648 is a reply to message #616637]

Thu, 19 June 2014 05:14

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

It is definitely being caused by one of the following:
1. The db_link
2. The merge statement
3. Something else

[Updated on: Thu, 19 June 2014 05:15]

Report message to a moderator

Re: ORA-01003: no statement parsed [message #616669 is a reply to message #616648]

Thu, 19 June 2014 07:13

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

See? What did I say? The Wizard is back and he already provided some useful hints.

Report message to a moderator

Re: ORA-01003: no statement parsed [message #616674 is a reply to message #616669]

Thu, 19 June 2014 08:59

sss111ind
Messages: 634
Registered: April 2012
Location: India

Senior Member

Though the reason is still unclear, but it might have occured because of long execution time. So we have modified the query
and now it's processing fine. Thanks to all.

Report message to a moderator

Previous Topic:	how to add mautiple partition on a table.
Next Topic:	ORA-01861: literal does not match format string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 05:19:06 CDT 2024