Solved

ORA-01003: no statement parsed

Posted on 2000-02-22
4
14,503 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
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:rwarsh
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle query help 18 99
unable to get sorting resultset 15 68
PL/SQL Search for multiple strings 5 39
Need help with fine tuning the windows batch script to change password 9 17
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now