Home » Developer & Programmer » Forms » ora-01403 (orcle,9i,xp)
ora-01403 [message #387500] Thu, 19 February 2009 10:07 Go to next message
venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india
Member
No Message Body
  • Attachment: 123.fmb
    (Size: 320.00KB, Downloaded 157 times)
Re: ora-01403 [message #387502 is a reply to message #387500] Thu, 19 February 2009 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01403: no data found

Regards
Michel
Re: ora-01403 [message #387506 is a reply to message #387500] Thu, 19 February 2009 10:45 Go to previous messageGo to next message
venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india
Member
venkatesh.M.P wrote on Thu, 19 February 2009 21:37


here it is showing ora-01403 error any help me to solve this issue
  • Attachment: TEXT3.TXT
    (Size: 2.94KB, Downloaded 166 times)
Re: ora-01403 [message #387508 is a reply to message #387500] Thu, 19 February 2009 10:53 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

The posted DDL can not & does not produce any ORA-01403 error.

CREATE TABLE fafixeddepositsm ( 
  slno           CHAR(10), 
  slano          CHAR(2), 
  entrydt        DATE, 
  bankcd         CHAR(3), 
  depositdt      DATE, 
  fdrno          VARCHAR2(20), 
  depositamt     NUMBER(15,2), 
  rateofinterest NUMBER(4,2), 
  maturitydt     DATE, 
  duration       VARCHAR2(10), 
  intamt         NUMBER(9,2), 
  tds            NUMBER(9,2), 
  netint         NUMBER(15,2), 
  totamt         NUMBER(15,2), 
  depositcd      CHAR(4), 
  reasoncd       CHAR(4), 
  remarks        VARCHAR2(100), 
  depositype     CHAR(1), 
  createby       CHAR(10), 
  createdt       DATE, 
  modifyby       CHAR(10), 
  modifydt       DATE) 
/ 

ALTER TABLE fafixeddepositsm 
ADD CONSTRAINT pk_fafixeddepositsm PRIMARY KEY ( Slno,SLANO ) 
/ 

ALTER TABLE fafixeddepositsm 
ADD CONSTRAINT fk_fafixeddepositsm_reasoncd FOREIGN KEY ( REASONCD ) References FaReasonM(REASONCD) 
/ 

ALTER TABLE fafixeddepositsm 
ADD CONSTRAINT fk_fafixeddepositsm_depositcd FOREIGN KEY ( DEPOSITcd ) References FADEPOSITTYPEM(DEPOSITcd) 
/ 

CREATE TABLE fareasonm ( 
  reasoncd CHAR(4)    NOT NULL, 
  reason   VARCHAR2(60)    NOT NULL, 
  createby VARCHAR2(10)    NOT NULL, 
  createdt DATE    NOT NULL, 
  modifyby VARCHAR2(10)    NOT NULL, 
  modifydt DATE    NOT NULL) 
/ 

ALTER TABLE fareasonm 
ADD CONSTRAINT pk_fareasonm PRIMARY KEY ( REASONCD ) 
/ 

CREATE TABLE fadeposittypem ( 
  depositcd   CHAR(4), 
  deposittype VARCHAR2(60)    NOT NULL, 
  createby    VARCHAR2(10)    NOT NULL, 
  createdt    DATE    NOT NULL, 
  modifyby    VARCHAR2(10)    NOT NULL, 
  modifydt    DATE    NOT NULL) 
/ 

ALTER TABLE fadeposittypem 
ADD CONSTRAINT pk_fadeposittypem PRIMARY KEY ( DEPOSITCD ) 
/ 

CREATE TABLE pmbankmaster ( 
  companycd CHAR(2)    NOT NULL, 
  bankcd    CHAR(3)    NOT NULL, 
  bankname  VARCHAR2(70)    NOT NULL, 
  createby  VARCHAR2(10)    NOT NULL, 
  createdt  DATE    NOT NULL, 
  modifyby  VARCHAR2(10), 
  modifydt  DATE) 
/


corrected invlaid DDL provided

[Updated on: Thu, 19 February 2009 11:20]

Report message to a moderator

Re: ora-01403 [message #387513 is a reply to message #387508] Thu, 19 February 2009 12:15 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post exact error message with your script..

ORA-01403
Re: ora-01403 [message #387519 is a reply to message #387500] Thu, 19 February 2009 13:18 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you have attached a form, I guess that one of its triggers is responsible for this error. I have downloaded it, but there are quite a few triggers and procedures so I wasn't particularly in a mood to review them all. If we had sample data, we might run the form; CREATE TABLE statements aren't enough.

Therefore, when this message appears, first try to select Help menu - Display error as it might reveal a statement/trigger which raised an exception. Otherwise, run the form in debug mode in order to find a culprit.
Re: ora-01403 [message #387572 is a reply to message #387519] Thu, 19 February 2009 23:01 Go to previous messageGo to next message
venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india
Member
i am getting error in afteramend entry pls check that one and how can we run the form in debug mode pls help me in this issue
Re: ora-01403 [message #387598 is a reply to message #387572] Fri, 20 February 2009 00:16 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Then this "afteramend entry" (whatever it is) is responsible for the error. What trigger gets fired when you enter a value? There's probably a SELECT ... INTO statement which doesn't return a value, and there's no EXCEPTION handler section which would handle NO-DATA-FOUND.

Debug mode? I have Forms 10g, and it is right here

./fa/5760/0/

P.S. I forgot to mention - you'll have to specify a breakpoint in one of form triggers (as close to error source as possible, in order to skip too many unimportant statements.

[Updated on: Fri, 20 February 2009 00:17]

Report message to a moderator

Re: ora-01403 [message #388231 is a reply to message #387500] Mon, 23 February 2009 23:43 Go to previous message
venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india
Member
thanks one and all who helped me in this issue
Previous Topic: Few typical queries
Next Topic: Updating a key column
Goto Forum:
  


Current Time: Thu Dec 08 02:09:38 CST 2016

Total time taken to generate the page: 0.09943 seconds