Solved

ORA-01003: no statement parsed

Posted on 2000-02-22
4
14,729 Views
Last Modified: 2012-06-27
I have a program written in C running on Unix, which will load a few tables from the Oracle database version 7.3.4.

In table A, there is only one record.
It seems that after loading table A, when it starts to load table B, the following errors messages are being produced. The strange part is, if table A is having zero or more than 1 records, then the program can be run successfully.

Unaligned access pid=11462 <bch> va=0x140280001 pc=0x3ffbfff8040 ra=0x3ffbfff804c inst=0xa6b50000
Unaligned access pid=11462 <bch> va=0x140280001 pc=0x3ffbfff8040 ra=0x3ffbfff804c inst=0xa6b50000
bch_MustParse: no such cursor found in the cursor list.

PETTY ERROR : Internal Error
FATAL ERROR : SQL Error
sql_execute
        status=1003, return code=1003, error position=0
ORA-01003: no statement parsed

Please help
0
Comment
Question by:ymlew
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 4

Expert Comment

by:sudhi022299
ID: 2547166
Looks like you have referenced a cursor which is either not declared or not opened.
paste your code here.
0
 
LVL 3

Expert Comment

by:Ron Warshawsky
ID: 2571423
ymlew,

  What are your status?

rwarsh
0
 

Author Comment

by:ymlew
ID: 2572115
It seems that the above errors are being caused by some other part of the code which causes some memory leak.

THanks for your help.
0
 
LVL 3

Accepted Solution

by:
oavidov earned 200 total points
ID: 2615914
ymlew,
I don't know exactly so I guess in target to help.
Check your memory allocation for 2nd table is one way for solution.
Cheak if you are marked EOF after compiler brings first table may be the 2nd way for solve it.
Assumption is it works properly when table A is without data.
oavidov
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to recover a database from a user managed backup

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question