ORA-01403: no data found + Oracle + Trigger

[Jigar Naik]

Hi i have created the following trigger in Oracle

  
CREATE OR REPLACE TRIGGER trg_ServiceRecovery AFTER INSERT ON dbo_SMSConnect.reportincomingsms
for each row
DECLARE
   pl_mobileno             VARCHAR2(50);
   pl_incomingmsgkey       NUMBER(20);
   pl_surveykey            VARCHAR2(20);
BEGIN
   SELECT  pkey INTO pl_surveykey FROM reportsmssurvey
           WHERE mobileno = :new.sendernumber and rownum=1 ORDER BY requestreceivetime desc;
insert into SurveyResponseAssociation values (pl_surveykey ,:new.pkey) ;
End;

but when i make insert on the following table reportincomingsms
it gives me following error

 
 
SQL> insert into reportincomingsms
  2  values(seq_reportincomingsms.nextval,'001','9969413222','hello from jigar','757525','15-Jan-08','done');
values(seq_reportincomingsms.nextval,'001','9969413222','hello from jigar','757525','15-Jan-08','done')
       *
ERROR at line 2:
ORA-01403: no data found
ORA-06512: at "DBO_SMSCONNECT.TRG_SERVICERECOVERY", line 6
ORA-04088: error during execution of trigger 'DBO_SMSCONNECT.TRG_SERVICERECOVERY'

[Avi Abrami]

Jigar,
The error message is telling you that the SELECT statement in your trigger did not return any rows.
I suggest you add an exception handler to your trigger.
No offence, but I fail to see how your question is related to this forum's topic: JDBC.
There is an Oracle forum, which is more appropriate, in my opinion.

Good Luck,
Avi.

[Jigar Naik]

oh ok.. thanks for the reply... it helped me a lot...