OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Update Record (APEX 4.2, Oracle 11g)

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

Update Record [message #579333]

Mon, 11 March 2013 07:39

inka
Messages: 14
Registered: February 2013

Junior Member

Hello All,

I have created a form manually and wrote an update statement. When I click on apply changes button I get the following error message:

Error Processing Validation
ORA-01722: invalid number

Here is the statement I am running:

declare
l_database_id number := :P20_DATABASE_ID;
l_application_id number := :P20_APPLICATION_ID;
begin

-- Create New Customer
update DATABASES set
SERVER_ID = :P20_SERVER_ID,
GLOBAL_DATABASE_NAME = :P20_GLOBAL_DATABASE_NAME,
DATABASE_NAME = :P20_DATABASE_NAME,
DBMS_RELEASE = :P20_DBMS_RELEASE,
DBMS_DESC = :P20_DBMS_DESC,
DB_ENVIRONMENT = :P20_DB_ENVIRONMENT,
TNS_PORT = :P20_TNS_PORT,
CREATE_DATE = :P20_CREATE_DATE,
INTERNAL_DB_ID = :P20_INTERNAL_DB_ID,
INACTIVE_FLAG = :P20_INACTIVE_FLAG,
UPDATE_DATE = :P20_UPDATE_DATE,
UPDATE_USERID = :P20_UPDATE_USERID;

UPDATE APPLICATION SET
APPLICATION_NAME = :P20_APPLICATION_NAME,
VENDOR_NAME = :P20_VENDOR_NAME,
VENDOR_INFO = :P20_VENDOR_INFO,
BCBEAR_URL = :P20_BCBEAR_URL,
CURRENT_VERSION = :P20_CURRENT_VERSION,
CRITICAL_FLAG = :P20_CRITICAL_FLAG,
INACTIVE_FLAG = :P20_APPLICATION_INACTIVE_FLAG,
UPDATE_DATE = :P20_UPDATE_DATE1,
UPDATE_USERID = :P20_UPDATE_USERID1;

commit;
end;

Can you tell why I am getting this error?

Thanks.

Report message to a moderator

Re: Update Record [message #579341 is a reply to message #579333]

Mon, 11 March 2013 08:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

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.

Report message to a moderator

Re: Update Record [message #579353 is a reply to message #579333]

Mon, 11 March 2013 09:11

c_stenersen
Messages: 255
Registered: August 2007

Senior Member

Quote:

Error Processing Validation
ORA-01722: invalid number

Also you should have a look in your validations. I'd say that's where the error is occurring, not in the process. (But the error might arise in the process as well afterwards of course, if your doing your validation on something which should be a number in the insert.)

Report message to a moderator

Previous Topic:	unable to change
Next Topic:	Simple ERD to Oracle SQL Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 12:57:22 CST 2024