Solved

Oracle 11.2 - ORA-01465: invalid hex number

Posted on 2013-07-01
4
7,579 Views
Last Modified: 2013-07-01
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_CONTENTTYPE,WIGDC_INBEARER,WIGDC_OUTBEARER) 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
0
Comment
Question by:joaotelles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39290051
Check WIG_DYNAMICCONTENT.  Is one or more of the columns declared as RAW?
0
 

Author Comment

by:joaotelles
ID: 39290068
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
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39290097
'http://localhost:7900/httper/CP_TSD/httpter/ST.TERMIITCH' is not a BLOB.

If you want to store this string in a BLOB field, you need to convert it.

drop table tab1 purge;
create table tab1(col1 blob);

--this fails
insert into tab1 values('http://www.notAblob.com');

--this works
insert into tab1 values(utl_raw.cast_to_raw('http://www.notAblob.com'));
commit;

Open in new window

0
 

Author Closing Comment

by:joaotelles
ID: 39290138
tks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question