Home » Developer & Programmer » Forms » error in inserting records from forms6i (strange)
| error in inserting records from forms6i (strange) [message #268025] |
Mon, 17 September 2007 03:18  |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
i m making message system.In the compose form which is used to send message to another person.i m facing a problem.when i click button to send message,error occurs.
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403
i m writing this code to save in database.
begin
insert into mesage(msg_no,teacher_id,receiver_id,msg_subject,mesage,msg_date)
values (:mesage.msg_txt,:mesage.teacher_id,:mesage.receiver_id,:mesage.msg_subject,:mesage.mesage,:mesage.msg_date);
end;
plz tell me any solution if any idea
thnks
[Updated on: Mon, 17 September 2007 03:19] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: error in inserting records from forms6i (strange) [message #268266 is a reply to message #268252] |
Tue, 18 September 2007 01:45  |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
yes i m using "pre-insert" triger and also doing selects.
i have written code to generate sequence number for "msg_no" in pre-insert trigger of form level.(this code is correctly generating sequence number)
select nvl(max(msg_no),0)+1 into :mesage.msg_txt
from mesage;
i have written this code in "when-new-form-instance" to get the person ID in a textbox, whose login ID is 1.(i m getting correct person ID in textbox)
select t.teacher_id into :mesage.teacher_id
from teacher t
where t.login_id = 1;
now i want to store all this information in database.
i m writing this code in "when-button-pressed "trigger against a button (send).
begin
/*to select person's ID against the name entered in the textbox(name)*/
select t.teacher_id into :mesage.receiver_id
from teacher t
where t.name = :mesage.name;
/*code for inserting vaules in database table (Mesage)*/
insert into mesage(msg_no,teacher_id,receiver_id,msg_subject,mesage,msg_date)
values (:mesage.msg_txt,:mesage.teacher_id,:mesage.receiver_id,:mesage.msg_subject,:mesage.mesage,:mesage.msg_date);
end;
but it is not inserting vaules in mesage table..it is generating error message.
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403
MESSAGE TABLE(where i want to save this information)
SQL> describe mesage;
Name Null? Type
------------------------------- -------- ----
MSG_NO NOT NULL NUMBER
RECEIVER_ID NUMBER
TEACHER_ID NUMBER(12)
MSG_SUBJECT VARCHAR2(50)
MESAGE VARCHAR2(500)
MSG_DATE DATE
plz tell me any solution
thnks
[Updated on: Tue, 18 September 2007 01:53] Report message to a moderator |
|
|
|
|
|
|
|
| Re: error in inserting records from forms6i (strange) [message #268450 is a reply to message #268274] |
Tue, 18 September 2007 12:51 |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
yes ,it is based on mesage table.But if i write "commit_form " on the "send" button to save it in database.It gives error"unable to insert .....".
Because one column does not exit in mesage table but it is on interface (textbox where i write receiver name,).There is no column in mesage table to save receiver name.In table receiver ID column exist.But on interface i want that user should write receiver name not his ID.
So i m doing manually inserting.
/*code for inserting vaules in database table (Mesage)*/
insert into mesage(msg_no,teacher_id,receiver_id,msg_subject,mesage,msg_date)
values (:mesage.msg_txt,:mesage.teacher_id,:mesage.receiver_id,:mesage.msg_subject,:mesage.mesage,:mesage.msg_date);
end;
any solution?
waiting for reply
thnks
[EDITED by LF: removed a huge BMP. Attach a JPG instead]
[Updated on: Tue, 18 September 2007 16:00] by Moderator Report message to a moderator |
|
|
|
| Re: error in inserting records from forms6i (strange) [message #268456 is a reply to message #268450] |
Tue, 18 September 2007 13:22 |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
i m attaching interface here and in interface u will see that on th top "oracle forms..." is written and below the toolbar "window 1". i want to eliminate it and want to write something else so plz tell me its solution for it,and solution of my previous problem.
thnks
[EDITED by LF: removed a huge BMP. Attach a JPG instead]
[Updated on: Tue, 18 September 2007 16:01] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: error in inserting records from forms6i (strange) [message #268540 is a reply to message #268524] |
Wed, 19 September 2007 01:04 |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
i have tried your suggestion (post query trigger) and getting correct result but now i want to insert entered records(msg_no,teacher_id,receiver_id,msg_subject,mesage,msg_date) in database.i dont want to save name in database table(mesage).
MESSAGE TABLE(where i want to save this information)
SQL> describe mesage;
Name Null? Type
------------------------------- -------- ----
MSG_NO NOT NULL NUMBER
RECEIVER_ID NUMBER
TEACHER_ID NUMBER(12)
MSG_SUBJECT VARCHAR2(50)
MESAGE VARCHAR2(500)
MSG_DATE DATE
i m writing this code on button to save data in database table
begin
insert into mesage(msg_no,teacher_id,receiver_id,msg_subject,mesage,msg_date)
values (:mesage.msg_txt,:mesage.teacher_id,:mesage.receiver_id,:mesage.msg_subject,:mesage.mesage,:mesage.msg_date);
end;
and getting error mesage
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01403
if u know any other solution to insert data in database plz tell me reply
thnks
[Updated on: Wed, 19 September 2007 01:07] Report message to a moderator |
|
|
|
|
|
| Re: error in inserting records from forms6i (strange) [message #268565 is a reply to message #268542] |
Wed, 19 September 2007 01:58 |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
i have tried the solution u told but not getting error msg,so now i m attaching interface so plz tell me wats the problem and its solution.
Database tables used in form
Mesage table(where i want to store date)
create table Mesage (msg_no number(*) , receiver_id number(*) ,teacher_id number(*) ,msg_subject varchar2(50),mesage varchar2(500),
msg_date date,
constraint pk_msg_no primary key(msg_no),
constraint fk_mt_id foreign key(teacher_id) references Teacher(teacher_id));
Teacher table(to get "name")
create table Teacher(teacher_id number(*) ,name varchar2(30),last_name varchar2(30),
constraint pk_Teach_id primary key(teacher_id));
Insert statments
insert into teacher1
values(11,'david','littlefoot');
insert into teacher1
values(12,'djmartin','maheer');
reply
thnks
[Updated on: Wed, 19 September 2007 02:00] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: error in inserting records from forms6i (strange) [message #268761 is a reply to message #268588] |
Wed, 19 September 2007 11:08 |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
SQL> describe login;
Name Null? Type
------------------------------- -------- ----
LOGIN_ID NOT NULL VARCHAR2(20)
USERNAME VARCHAR2(30)
PASSWORD VARCHAR2(30)
ROLE VARCHAR2(30)
SQL> describe teacher;
Name Null? Type
------------------------------- -------- ----
TEACHER_ID NOT NULL NUMBER(12)
LOGIN_ID VARCHAR2(20)
NAME VARCHAR2(30)
LAST_NAME VARCHAR2(30)
SQL> describe mesage;
Name Null? Type
------------------------------- -------- ----
MSG_NO NOT NULL NUMBER
RECEIVER_ID NUMBER
TEACHER_ID NUMBER(12)
MSG_SUBJECT VARCHAR2(50)
MESAGE VARCHAR2(500)
MSG_DATE DATE
Table description:
create table login (login_id VARCHAR2(20),username VARCHAR2(30),password VARCHAR2(30),role varchar2(30),
constraint pk_log_id primary key(login_id));
create table Teacher(teacher_id number(12),login_id ,name varchar2(30),last_name varchar2(30),
constraint pk_Teach_id primary key(teacher_id),
constraint fk_log_id foreign key(login_id) references login(login_id));
create table Mesage (msg_no number(*) , receiver_id number(*) ,teacher_id number(12) ,msg_subject varchar2(50),mesage varchar2(500),
msg_date date,
constraint pk_msg_no primary key(msg_no),
constraint fk_mt_id foreign key(teacher_id) references Teacher(teacher_id));
insert statements:
for login table:
insert into login
values(1,'david','david','admin');
insert into login
values(2,'djmartin','djmartin','teacher');
for teacher table:
insert into teacher
values(11,1,'david','littlefoot');
insert into teacher
values(12,2,'djmartin','maheer');
This time nothing missing.ok
[Updated on: Wed, 19 September 2007 11:24] Report message to a moderator |
|
|
|
|
|
| Re: error in inserting records from forms6i (strange) [message #269441 is a reply to message #268862] |
Sat, 22 September 2007 05:47 |
anisam10674
Messages: 18
Registered: March 2007
|
Junior Member |
|
|
Not sure but pre-insert trigger of the form can be changed to
select max(nvl(msg_no,0)+1 into :mesage.msg_txt from mesage;
--------------------------------------------------------
yes i m using "pre-insert" triger and also doing selects.
i have written code to generate sequence number for "msg_no" in pre-insert trigger of form level.(this code is correctly generating sequence number)
select nvl(max(msg_no),0)+1 into :mesage.msg_txt
from mesage;
|
|
|
|
Goto Forum:
Current Time: Fri Sep 27 04:20:28 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
