Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-05 : 09:07:14
|
Davor writes "Here is a part of my code. I need to check if QA_table exist before I can execute this, and I need to check if QA_table contains this "ID". Right now if the ID is not in the table it crashes and displays "error:100 ORA-01403: no data found
ORA-06512: at line 5."
Is there some way to figure this out?
Thanks
--get actual counts of BID, SID, PUR records
select distinct num_bid_records into BIDactual from QA_table where log_file_oid = ID;
select distinct num_sid_records into SIDactual from QA_table where log_file_oid = ID;
select distinct num_pur_records into PURactual from QA_table where log_file_oid = ID;
" |
|
|
|
|
|
Check if table exist/if it contains that entry