Home » Developer & Programmer » Forms » FRM-40505 (forms 6i)
FRM-40505 [message #396797] Wed, 08 April 2009 01:34 Go to next message
rakhatmis
Messages: 25
Registered: March 2008
Junior Member
Hi all
I am using forms 6i. I have a search option in all my forms but the problem is that in one of the forms this option is not working while its working perfectly fine in rest of the forms. The details regarding error are:

FRM-40505: ORACLE error: unable to perform query
ORA-01722: invalid number
Code behind search button
SET_BLOCK_PROPERTY('PERSONALINFORMATION',DEFAULT_WHERE,'EMPLOYEEID = ' || :PERSONALINFORMATION.SEARCHID);
go_item('SEARCHID'); 
EXECUTE_QUERY;


Database Item property set to 'No'
 Name                            Null?    Type
 ------------------------------- -------- ----
[B] EMPLOYEEID                      NOT NULL VARCHAR2(20)[/B]
 FULLNAME                                 VARCHAR2(30)
 FATHERNAME                               VARCHAR2(30)
 GENDER                                   VARCHAR2(6)
 DATEOFBIRTH                              DATE
 CNIC                                     NUMBER(13)
 NTN                                      NUMBER(20)
 NATIONALITY                              VARCHAR2(15)
 RELIGION                                 VARCHAR2(10)
 IDENTIFICATIONMARK                       VARCHAR2(50)
 PASSPORTNO                               VARCHAR2(20)
 BLOODGROUP                               VARCHAR2(3)
 PLACEOFBIRTH                             VARCHAR2(15)
 QUALIFICATION                            VARCHAR2(20)
 DOMICILE                                 VARCHAR2(20)
 SECT                                     VARCHAR2(10)
 DATEOFJOINING                            DATE
 DESIGNATION                              VARCHAR2(20)
 BPS                                      NUMBER(2)
 DEPARTMENTNAME                           VARCHAR2(20)
 CENTRE                                   VARCHAR2(20)
 JOBSTATUS                                VARCHAR2(12)
 FIELD                                    VARCHAR2(50)
 SPECILIAZATION                           VARCHAR2(100)
 SADATE                                   DATE
 TOTALEXPERIENCE                          NUMBER(2)
 EMPLOYEEPHOTO                            BLOB
 [B]SEARCHID                                 VARCHAR2(20)[/B]
 SEARCHNAME                               VARCHAR2(30)
 LASTUPDATEDON                            DATE


Kindly help me. Waiting for some early replies.
Re: FRM-40505 [message #396811 is a reply to message #396797] Wed, 08 April 2009 02:01 Go to previous messageGo to next message
expertsudhir
Messages: 26
Registered: October 2008
Location: Delhi, India
Junior Member

ORA-01722 invalid number

Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions. Only numeric fields may be added to or subtracted from dates.

Action: Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation.

I think it would solve your problem.
Re: FRM-40505 [message #396819 is a reply to message #396811] Wed, 08 April 2009 02:11 Go to previous messageGo to next message
rakhatmis
Messages: 25
Registered: March 2008
Junior Member
Thanks for reply
it didn't solve my problem.
Re: FRM-40505 [message #396830 is a reply to message #396819] Wed, 08 April 2009 02:24 Go to previous messageGo to next message
expertsudhir
Messages: 26
Registered: October 2008
Location: Delhi, India
Junior Member

Try:

SET_BLOCK_PROPERTY('PERSONALINFORMATION',DEFAULT_WHERE,'EMPLOYEEID = ' ||Chr(39)||:PERSONALINFORMATION.SEARCHID||Chr(39));
Go_Block('PERSONALINFORMATION');
EXECUTE_QUERY;

Re: FRM-40505 [message #396873 is a reply to message #396830] Wed, 08 April 2009 04:28 Go to previous message
rakhatmis
Messages: 25
Registered: March 2008
Junior Member
Thanks it worked
Previous Topic: tree
Next Topic: DML Returning Value, on-update and field update
Goto Forum:
  


Current Time: Thu Dec 08 02:18:59 CST 2016

Total time taken to generate the page: 0.11190 seconds