joaotelles
asked on
Oracle 11.2 - ORA-01465: invalid hex number
Hi,
Pls I need help on finding out why Im getting this error below:
DECLARE
EXISTS_ROW NUMBER :=0;
BEGIN
SELECT COUNT(*) INTO EXISTS_ROW FROM WIG_STATICURLREFERENCE ref WHERE ref.SURL_REFERENCE='*tsd';
IF EXISTS_ROW=0 THEN
INSERT INTO WIG_DYNAMICCONTENT (WIGDC_NAME, WIGDC_CONTENT,WIGDC_CONTEN TTYPE,WIGD C_INBEARER ,WIGDC_OUT BEARER) VALUES
('*tsd', 'http://localhost:7900/httper/CP_TSD/httpter/ST.TERMIITCH',0,2,2);
ELSE
UPDATE WIG_DYNAMICCONTENT SET WIGDC_CONTENT='http://localhost:7900/httpeventadapter/CP_WIBTSD/httpAdapter/ST.TERMINAL_SWITCH'
WHERE WIGDC_NAME='*tsd' and WIGDC_CONTENTTYPE=0 AND WIGDC_INBEARER=2 AND WIGDC_OUTBEARER=2;
END IF;
END;
Error code: 1465
Oracle error: ORA-01465: invalid hex number
Tks,
Joao
Pls I need help on finding out why Im getting this error below:
DECLARE
EXISTS_ROW NUMBER :=0;
BEGIN
SELECT COUNT(*) INTO EXISTS_ROW FROM WIG_STATICURLREFERENCE ref WHERE ref.SURL_REFERENCE='*tsd';
IF EXISTS_ROW=0 THEN
INSERT INTO WIG_DYNAMICCONTENT (WIGDC_NAME, WIGDC_CONTENT,WIGDC_CONTEN
('*tsd', 'http://localhost:7900/httper/CP_TSD/httpter/ST.TERMIITCH',0,2,2);
ELSE
UPDATE WIG_DYNAMICCONTENT SET WIGDC_CONTENT='http://localhost:7900/httpeventadapter/CP_WIBTSD/httpAdapter/ST.TERMINAL_SWITCH'
WHERE WIGDC_NAME='*tsd' and WIGDC_CONTENTTYPE=0 AND WIGDC_INBEARER=2 AND WIGDC_OUTBEARER=2;
END IF;
END;
Error code: 1465
Oracle error: ORA-01465: invalid hex number
Tks,
Joao
Check WIG_DYNAMICCONTENT. Is one or more of the columns declared as RAW?
ASKER
SQL> desc WIG_DYNAMICCONTENT
Name Null? Type
-------------------------- ---------- ----- -------- -------------------------- --
WIGDC_NAME NOT NULL VARCHAR2(50)
WIGDC_TYPE NOT NULL NUMBER
WIGDC_INBEARER NOT NULL NUMBER
WIGDC_OUTBEARER NOT NULL NUMBER
WIGDC_CONTENTTYPE NOT NULL NUMBER
WIGDC_CONTENTENCODING NOT NULL NUMBER
WIGDC_PARENT VARCHAR2(50)
WIGDC_MENUTEXTENCODING NOT NULL NUMBER
WIGDC_MENUPOSITION NOT NULL NUMBER
WIGDC_RESPENCODING NOT NULL NUMBER
WIGDC_CHANGEDDATE NOT NULL DATE
WIGDC_CONTENT BLOB
WIGDC_MENUTEXT BLOB
WIGDC_RESPTEXT BLOB
Name Null? Type
--------------------------
WIGDC_NAME NOT NULL VARCHAR2(50)
WIGDC_TYPE NOT NULL NUMBER
WIGDC_INBEARER NOT NULL NUMBER
WIGDC_OUTBEARER NOT NULL NUMBER
WIGDC_CONTENTTYPE NOT NULL NUMBER
WIGDC_CONTENTENCODING NOT NULL NUMBER
WIGDC_PARENT VARCHAR2(50)
WIGDC_MENUTEXTENCODING NOT NULL NUMBER
WIGDC_MENUPOSITION NOT NULL NUMBER
WIGDC_RESPENCODING NOT NULL NUMBER
WIGDC_CHANGEDDATE NOT NULL DATE
WIGDC_CONTENT BLOB
WIGDC_MENUTEXT BLOB
WIGDC_RESPTEXT BLOB
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
tks