Home » Developer & Programmer » Application Express & MOD_PLSQL » Update Record (APEX 4.2, Oracle 11g)
Update Record [message #579333] Mon, 11 March 2013 07:39 Go to next message
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.
Re: Update Record [message #579341 is a reply to message #579333] Mon, 11 March 2013 08:13 Go to previous messageGo to next message
Littlefoot
Messages: 19686
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.
Re: Update Record [message #579353 is a reply to message #579333] Mon, 11 March 2013 09:11 Go to previous message
c_stenersen
Messages: 254
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.)
Previous Topic: unable to change
Next Topic: Simple ERD to Oracle SQL Question
Goto Forum:
  


Current Time: Tue Oct 21 10:29:33 CDT 2014

Total time taken to generate the page: 0.05334 seconds