Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No data found exception from UPDATE statement

289596Sep 3 2002
I am trying to issue an UPDATE statement in a procedure in a package.

I use DBMS_OUTPUT.PUT_LINE to list all of the values Im trying to set.

My update statement looks like:
UPDATE table_name
SET ack_dtg = to_date(v_ack_datetime,'DD-MON-YY HH24:MI:SS'),
ack_error_code = v_err,
latest_dtg = SYSDATE,
latest_status_id = v_status_id,
original_dtg = v_time,
sent_count = v_count + 1
WHERE message_id = v_id;

All the variables on the right side of the equal sign have values that I can see using DBMS_OUTPUT.PUT_LINE.

I get and error that says:
ORA-01403: no data found
ORA-06512: at "SAMS.SI_TMIP_ACK_LIB", line 101
ORA-01403: no data found
ORA-06512: at line 1

I know its the input statement because my call to show the variable values is just before the UPDATE statement. Then I have an output statement right after the UPDATE statement that is not shown.

Any suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2002
Added on Sep 3 2002
3 comments
4,730 views