Solved

ORA-01003: no statement parsed

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the version of ojdbc6.jar 2 56
Converting a row into a column 2 51
Query Records that don't match 8 42
Shredding xml into an oracle 11g Database 2 43
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

786 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