OraFAQ Forum: Forms » FRM-40505

Home » Developer & Programmer » Forms » FRM-40505 (forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40505 [message #396797]

Wed, 08 April 2009 01:34

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.

Report message to a moderator

Re: FRM-40505 [message #396811 is a reply to message #396797]

Wed, 08 April 2009 02:01

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.

Report message to a moderator

Re: FRM-40505 [message #396819 is a reply to message #396811]

Wed, 08 April 2009 02:11

rakhatmis
Messages: 25
Registered: March 2008

Junior Member

Thanks for reply
it didn't solve my problem.

Report message to a moderator

Re: FRM-40505 [message #396830 is a reply to message #396819]

Wed, 08 April 2009 02:24

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;

Report message to a moderator

Re: FRM-40505 [message #396873 is a reply to message #396830]

Wed, 08 April 2009 04:28

rakhatmis
Messages: 25
Registered: March 2008

Junior Member

Thanks it worked

Report message to a moderator

Previous Topic:	tree
Next Topic:	DML Returning Value, on-update and field update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:51:37 CST 2025