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.