-
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.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|