OraFAQ Forum: Server Utilities » Token longer than max allowable length of 258 chars

Home » RDBMS Server » Server Utilities » Token longer than max allowable length of 258 chars

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Token longer than max allowable length of 258 chars [message #122353]

Mon, 06 June 2005 02:42

talp
Messages: 2
Registered: June 2005

Junior Member

Hi,
>
> When I am using the Sql Loader I get this Error:
> "Token longer than max allowable length of 258 chars"
>
> I am trying to use a long decode function and I don't know how to cut it.
>
> the function looks like this:
> APN "decode(:APN, 'Audio_MMS_email', 352062000001,
> decode(:APN, 'Audio_MMS_LuxGSM', 352061000002,
> decode(:APN, 'Audio_MMS_Tango', 352060000003,
> decode(:APN, 'Audio_MMS_VOX', 352059000004,
> decode(:APN, 'Audio_MMS_zone1', 352058000005,
> decode(:APN, 'GC_VOX', 352057000006,
> decode(:APN, 'Image_MMS_email', 352056000007,
> decode(:APN, 'Image_MMS_LuxGSM', 352055000008,
> decode(:APN, 'Image_MMS_Tango', 352054000009,
> decode(:APN, 'Image_MMS_VOX', 352053000010,
> decode(:APN, 'Image_MMS_zone1', 352052000011,
> decode(:APN, 'MM_MMS_LuxGSM', 352051000012,
> decode(:APN, 'MM_MMS_Tango', 352050000013,
> decode(:APN, 'MM_MMS_VOX', 352049000014,
> decode(:APN, 'MM_MMS_zone1', 352048000015,
> decode(:APN, 'SMS_LuxGSM', 352047000016,
> decode(:APN, 'SMS_routed_VOX', 352046000017,
> decode(:APN, 'SMS_Satellite', 352045000018,
> decode(:APN, 'SMS_Tango', 352044000019,
> decode(:APN, 'SMS_VOX', 352043000020,
> decode(:APN, 'SMS_Zone1', 352042000021,
> decode(:APN, 'SMS_Zone2', 352041000022,
> decode(:APN, 'SMS_Zone3', 352040000023,
> decode(:APN, 'SMS_Zone4', 352039000024,
> decode(:APN, 'Text_MMS_email', 352038000025,
> decode(:APN, 'Text_MMS_LuxGSM', 352037000026,
> decode(:APN, 'Text_MMS_Tango', 352036000027,
> decode(:APN, 'Text_MMS_VOX', 352035000028,
> decode(:APN, 'Text_MMS_zone1', 352034000029,
> decode(:APN, 'Text_routed_MMS_VOX', 352033000030,
> decode(:APN, 'Video_MMS_email', 352032000031,
> decode(:APN, 'Video_MMS_LuxGSM', 352031000032,
> decode(:APN, 'Video_MMS_Tango', 352030000033,
> decode(:APN, 'Video_MMS_VOX', 352029000034,
> decode(:APN, 'Video_MMS_zone1', 352028000035,
> decode(:APN, 'Other_MMS_email', 352027000036,
> decode(:APN, 'Other_MMS_LuxGSM', 352026000037,
> decode(:APN, 'Other_MMS_Tango', 352025000038,
> decode(:APN, 'Other_MMS_VOX', 352024000039,
> decode(:APN, 'Other_MMS_zone1', 352023000040))))) )))))
> ))))) ))))) ))))) ))))) ))))) ))))),
>
> Please advise
>
>
> Best regards.
> Tal

Report message to a moderator

Re: Token longer than max allowable length of 258 chars [message #122381 is a reply to message #122353]

Mon, 06 June 2005 05:07

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Try to remove the unnecessary decodes from the token:

APN "decode(:APN, 'Audio_MMS_email',  352062000001,
                  'Audio_MMS_LuxGSM', 352061000002,
                  'Audio_MMS_Tango',  352060000003,
                  'Audio_MMS_VOX',    352059000004,
                  'Audio_MMS_zone1',  352058000005,
...

If it's still to long, try to remove all spaces.

Best regards.

Frank

Report message to a moderator

Re: Token longer than max allowable length of 258 chars [message #122441 is a reply to message #122381]

Mon, 06 June 2005 09:38

talp
Messages: 2
Registered: June 2005

Junior Member

Thanks, but it is still too long, even after i removed
all spaces.
Is there anything else I can do ?

Report message to a moderator

Re: Token longer than max allowable length of 258 chars [message #122444 is a reply to message #122441]

Mon, 06 June 2005 09:43

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

load the data as-is into a staging table and use sql methods to decode the data and then load into the original table.
Getting the external data into oracle is task. Once it is inside the oracle database, you have tons of options.

Report message to a moderator

Re: Token longer than max allowable length of 258 chars [message #122449 is a reply to message #122444]

Mon, 06 June 2005 09:59

Maaher
Messages: 7065
Registered: December 2001

Senior Member

That's exactly how we handle our external data here, through staging tables.

MHE

Report message to a moderator

Previous Topic:	Why to the instructions and examples for logminer scrape so bad?
Next Topic:	Loading data into table using SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 07:44:54 CDT 2024