Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Error: ORA-00972: identifier is too long

575697May 3 2007 — edited May 3 2007

I want to insert a blob into my create script with this insert query. But i get the error
Error at Command Line:3 Column:1
Error report:
SQL Error: ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.

any ideas?

insert into image_templates(image_template_id,name,description,min_cm,template_blob,template_name
,template_mime,max_images) values ('12','test','test','10',
FFD8FFE000104A46494600010101006000600000FFE1001645786966000049492A0008000000000000000000FFDB00
4300080606070605080707070909080A0C140D0C0B0B0C1912130F141D1A1F1E1D1A1C1C20242E2720222C231C1C283
7292C30313434341F27393D38323C2E333432FFDB0043010909090C0B0C180D0D1832211C2132323232323232323232
32323232323232323232323232323232323232323232323232323232323232323232323232323232FFC000110801800
20003012200021101031101FFC4001F0000010501010101010100000000000000000102030405060708090A0BFFC400
B5100002010303020403050504040000017D01020300041105122131410613516107227114328191A1082342B1C1155
2D1F02433627282090A161718191A25262728292A3435363738393A434445464748494A535455565758595A63646566
6768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC
2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F010003010101
0101010101010000000000000102030405060708090A0BFFC400B511000201020404030407050404000102770001020
31104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26272829
2A35363738393A434445464748494A535455565758595A636465666768696A737475767778797A82838485868788898
A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3
E4E5E6E7E8E9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00F7FAF3FF00F85DBF0F7FE861FF00C92B8FF
E375E815F1F7C27F0669DE3AF14DCE99A9CD750C31593DC2B5B32AB160E8B83B958630E7B7A5007D03FF0BB7E1EFF00
D0C3FF0092571FFC6E8FF85DBF0F7FE861FF00C92B8FFE375CFF00FC339783FF00E825AE7FDFF87FF8D51FF0CE5E0FF
F00A096B9FF007FE1FF00E35401D07FC2EDF87BFF00430FFE495C7FF1BA3FE176FC3DFF00A187FF0024AE3FF8DD73FF
00F0CE5E0FFF00A096B9FF007FE1FF00E3547FC339783FFE825AE7FDFF0087FF008D500741FF000BB7E1EFFD0C3FF92
571FF00C6E8FF0085DBF0F7FE861FFC92B8FF00E375CFFF00C339783FFE825AE7FDFF0087FF008D51FF000CE5E0FF00
FA096B9FF7FE1FFE35401D07FC2EDF87BFF430FF00E495C7FF001BA3FE176FC3DFFA187FF24AE3FF008DD73FFF000CE
5E0FF00FA096B9FF7FE1FFE3547FC339783FF00E825AE7FDFF87FF8D500741FF0BB7E1EFF00D0C3FF0092571FFC6E8F
F85DBF0F7FE861FF00C92B8FFE375CFF00FC339783FF00E825AE7FDFF87FF8D51FF0CE5E0FFF00A096B9FF007FE1FF0
0E35401D07FC2EDF87BFF00430FFE495C7FF1BA3FE176FC3DFF00A187FF0024AE3FF8DD73FF00F0CE5E0FFF00A096B9
FF007FE1FF00E3547FC339783FFE825AE7FDFF0087FF008D500741FF000BB7E1EFFD0C3FF92571FF00C6E8FF0085DBF
0F7FE861FFC92B8FF00E375CFFF00C339783FFE825AE7FDFF0087FF008D51FF000CE5E0FF00FA096B9FF7FE1FFE3540
,'test','test',10)

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2007

Added on May 3 2007

#general-database-discussions

1 comment

678 views