error msg:ORA-01403 - no data found

I am running Micro-Focus Cobol to access data from oracle tables. This program is trying to access data from student subject file, however the program booms out with this error message: SQL Error in ACSSUBJ>>ORA-1403:NO DATA FOUND. The program accesses the other two files well before this one.

Can you help me please, I need to get this done before school begins.
mserumAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mserumAuthor Commented:
Can you give me some hints.
0
mserumAuthor Commented:
Adjusted points to 300
0
pagerbakCommented:
This is the the standard response from Oracle, when no data match your query.
Check where clause of your statement again, or perhaps there are no rows in the student table.
In case your statement is correct and you really expect to retrieve some data, perhaps you are not accessing the table you think you are. There may be a view or public (or private) synonym that points to a table other than the one you expect to access.
If you still have trouble, please show us your sql and the data from a row you expect to retrieve.

Regards
pagerbak
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

mserumAuthor Commented:
Thank you pagerbak. I want to make it more clear to you. I am using Micro-Focus Cobol to read oracle tables. I have checked my data and they exist. Infact, first three records are being read and when it comes to the fourth record it booms out with the error msg as stated above in the question.

Thanks.
0
pagerbakCommented:
I guess you are using a cursor to retrieve the rows, and then the 1403 just signals, that no more rows match your query.
0
crsankarCommented:
Can you provide the sql statement please
0
mserumAuthor Commented:
Yes crsanker, here is my Sql statement.
EXEC SQL DELETE FROM SUBJECT_MASTER_FILE
  WHERE SUJ_STUDENT_NUMBER =
           :SQL_STUDENT_NUMBER AND
        SUBJ_YEAR = :SQL_SUBJ_YEAR AND
        SUBJ_SUBJECT_CODE =
           :SQL_SUBJ_SUBJECT_CODE AND
        SUBJ_SEMESTER
           = :SQL_SUBJ_SEMESTER
END-EXEC.

There is a particular student number that appears every time I compile and run the program, that student does not exit in any of my tables. Whenever that number appears the system booms out with the error msg ora-1403:no data found.
See if you can help otherwise it must be something more to that I believe.

Thanks.
0
crsankarCommented:
Have you tried executing the same statement from SQL*PLus or some similar tool. If so, what are the results. It could be that, there are no matching records according to the criteria specified. If it works from sql*plus make sure that the parameter values are supplied correctly. I mean, wether it is in proper case and so on.
0
pagerbakCommented:
pagerbak changed their proposed answer to a comment
0
pagerbakCommented:
Are you absolutely sure, that there is a row in SUBJECT_MASTER_FILE, that matches what you have in SQL_STUDENT_NUMBER, SQL_SUBJ_YEAR,
SQL_SUBJ_SUBJECT_CODE AND SQL_SUBJ_SEMESTER?


0
pagerbakCommented:
Are you absolutely sure, that there is a row in SUBJECT_MASTER_FILE, that matches what you have in SQL_STUDENT_NUMBER, SQL_SUBJ_YEAR,
SQL_SUBJ_SUBJECT_CODE AND SQL_SUBJ_SEMESTER?


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.