Home » Developer & Programmer » Forms » ora-01403 (orcle,9i,xp)
|
|
|
Re: ora-01403 [message #387508 is a reply to message #387500] |
Thu, 19 February 2009 10:53 |
|
BlackSwan
Messages: 26766 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 #387572 is a reply to message #387519] |
Thu, 19 February 2009 23:01 |
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 |
|
Littlefoot
Messages: 21823 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
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
|
|
|
|
Goto Forum:
Current Time: Mon Feb 03 20:43:59 CST 2025
|