error related to BLOB data type
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: error related to BLOB data type

Hybrid View

  1. #1
    Join Date
    May 2008
    Posts
    1

    error related to BLOB data type

    Hi All,

    Here i got an error while excuting the following query related to BLOB data types in Oracle 11g.
    I have to compare two blobs, because my report needs that.
    for this..1st i ran the following package..

    @ORACLE_HOME/rdbms/admin/dbmslob.sql
    then i did this...
    declare
    src_lob BFILE := &src_lob;
    amount INTEGER := &amount;
    dest_offset INTEGER :=1;
    src_offset INTEGER :=1;
    dest_lob BLOB := &dest_lob;
    BEGIN
    dbms_lob.loadfromfile
    (
    dest_lob,
    amount,
    src_lob,
    src_offset,
    dest_offset
    );
    end;
    SQL> /
    Enter value for src_lob: 0820303623ECCFF8DCD9E0DFF11FDF1E1E7C3E6450E444E2E683A3D
    B03FF7B7CFF34FC24244724CF07CBDBC8EB80C034000436007E018801016B01FEFFFEFEFEFE0F7F0
    D07891FF198F1E9E1F304730C
    old 2: 2 src_lob BFILE := &src_lob;
    new 2: 2 src_lob BFILE := 0820303623ECCFF8DCD9E0DFF11FDF1E1E7C3E6450E444E2E
    683A3DB03FF7B7CFF34FC24244724CF07CBDBC8EB80C034000436007E018801016B01FEFFFEFEFEF
    E0F7F0D07891FF198F1E9E1F304730C;
    Enter value for amount: 18446744073709551615
    old 3: 3 amount INTEGER := &amount;
    new 3: 3 amount INTEGER := 18446744073709551615;
    Enter value for dest_lob: 8F2F1FE032E0E0C8C00CF91E2E1F0EDBDDF2D13292203E61614161
    80C0E689FFAEFFD7FEDF38FC3818013941F1C7C4C74FF3FF90F218000D1CAD9F89ED00E000024404
    D76DDFD6DF935F5B0E5C868E87
    old 6: 6 dest_lob BLOB := &dest_lob;
    new 6: 6 dest_lob BLOB := 8F2F1FE032E0E0C8C00CF91E2E1F0EDBDDF2D13292203E616
    1416180C0E689FFAEFFD7FEDF38FC3818013941F1C7C4C74FF3FF90F218000D1CAD9F89ED00E0000
    24404D76DDFD6DF935F5B0E5C868E87;
    ERROR:
    ORA-00972: identifier is too long


    SQL> declare
    2 lob_1 BLOB := &lob_1;
    3 lob_2 BLOB := &lob_2;
    4 amount INTEGER := 18446744073709551615;
    5 offset1 INTEGER :=1;
    6 offset2 INTEGER :=1;
    7 templob INTEGER;
    8 BEGIN
    9 templob :=dbms_lob.compare(lob_1,lob_2,amount,offset1,offset2);
    10 if (templob !=0 ) then
    11 dbms_output.put_line('Files Are Different');
    12 else
    13 dbms_output.put_line('Files Are Same');
    14 end if;
    15 end;
    16 /
    Enter value for lob_1: 0820303623ECCFF8DCD9E0DFF11FDF1E1E7C3E6450E444E2E683A3DB0
    3FF7B7CFF34FC24244724CF07CBDBC8EB80C034000436007E018801016B01FEFFFEFEFEFE0F7F0D0
    7891FF198F1E9E1F304730C
    old 2: lob_1 BLOB := &lob_1;
    new 2: lob_1 BLOB := 0820303623ECCFF8DCD9E0DFF11FDF1E1E7C3E6450E444E2E683A3DB0
    3FF7B7CFF34FC24244724CF07CBDBC8EB80C034000436007E018801016B01FEFFFEFEFEFE0F7F0D0
    7891FF198F1E9E1F304730C;
    Enter value for lob_2: 8F2F1FE032E0E0C8C00CF91E2E1F0EDBDDF2D13292203E6161416180C
    0E689FFAEFFD7FEDF38FC3818013941F1C7C4C74FF3FF90F218000D1CAD9F89ED00E000024404D76
    DDFD6DF935F5B0E5C868E87
    old 3: lob_2 BLOB := &lob_2;
    new 3: lob_2 BLOB := 8F2F1FE032E0E0C8C00CF91E2E1F0EDBDDF2D13292203E6161416180C
    0E689FFAEFFD7FEDF38FC3818013941F1C7C4C74FF3FF90F218000D1CAD9F89ED00E000024404D76
    DDFD6DF935F5B0E5C868E87;
    ERROR:
    ORA-00972: identifier is too long

    i do not know why i got this problem.. is there any error in my program..
    lobmaxsize=4GB
    how to increase the size of the data type.
    Please Help me.

    Thank You.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    You have to look at the whole error stack, I'm pretty sure you are also getting a ORA-06512 error. Look into it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,476

    Talking

    Maybe it's because a BFILE column or attribute stores a BFILE locator, which serves as a pointer to a binary file on the server file system. The locator maintains the directory name and the filename.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width