Home » SQL & PL/SQL » SQL & PL/SQL » Error ORA-01460
Error ORA-01460 [message #336926] Tue, 29 July 2008 06:51 Go to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Hi,

I am getting an exception,

ORA-01460: unimplemented or unreasonable conversion requested when I try to use the below code to split a string
select substr(psStyleNum,
                            instr(','||psStyleNum||',', ',', 1, rn),
                            instr(','||psStyleNum||',', ',', 1, rn+1)
                            - instr(','||psStyleNum||',', ',', 1, rn) - 1) value
                            from (select rownum rn from dual
                            connect by level <= length(psStyleNum)-length(replace(psStyleNum,',',''))+1)


psStyleNum is a list of comma separated values, for e.g.

'1234567890123,1234567890123,1234567890123,1234567890123,
1234567890123,1234567890123,1234567890123,1234567890123'

When this list goes beyond 4k, I encounter the above problem.

Could you please suggest some other way of splitting this?

Thanks,

Sharath
Re: Error ORA-01460 [message #336941 is a reply to message #336926] Tue, 29 July 2008 07:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Always post your Oracle version (4 decimals)

2/ Post a valid statement that we can execute.

Regards
Michel
Re: Error ORA-01460 [message #336956 is a reply to message #336941] Tue, 29 July 2008 07:57 Go to previous messageGo to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Michel,

Thanks for that.

Oracle Version 10.2.0.1

The statement mentioned below is used in a stored procedure.

psstylenum is an input parameter

select substr('1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,hgfhgdsfggdfg',
                            instr(','||'1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,hgfhgdsfggdfg'||',', ',', 1, rn),
                            instr(','||'1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,hgfhgdsfggdfg'||',', ',', 1, rn+1)
                            - instr(','||'1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,hgfhgdsfggdfg'||',', ',', 1, rn) - 1) value
                            from (select rownum rn from dual
                            connect by level <= length('1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,hgfhgdsfggdfg')-length(replace('1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,1234567890123,hgfhgdsfggdfg',',',''))+1)


When I run the query alone, the error thrown is 0RA-01704 The string literal is too long
Re: Error ORA-01460 [message #336983 is a reply to message #336956] Tue, 29 July 2008 09:54 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Try to use CLOBs instead of VARCHAR2s in the procedure.

Note: The level of detail in any answer can only be as high as the level of detail in the question.



Re: Error ORA-01460 [message #336987 is a reply to message #336956] Tue, 29 July 2008 10:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
String is limited to 4000 characters in SQL.
Post an example that reproduce your error and is as small as possible.

Regards
Michel
Re: Error ORA-01460 [message #336999 is a reply to message #336987] Tue, 29 July 2008 10:53 Go to previous messageGo to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Michel,

Thanks for your reply.

Is there some way this limit of 4000 could be increased?

I cannot use clobs as the susbtr function does not work on clob.

Is there some replacement for substr and instr that works on clob?

Thanks,

Sharath

Re: Error ORA-01460 [message #337000 is a reply to message #336999] Tue, 29 July 2008 10:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, substr works on clob in 10.2

Regards
Michel
Re: Error ORA-01460 [message #337001 is a reply to message #336999] Tue, 29 July 2008 11:02 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
I cannot use clobs as the susbtr function does not work on clob.


wrong

Quote:

char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.

Previous Topic: Set a order to execute triggers of the same type
Next Topic: Start value of sequence 00001
Goto Forum:
  


Current Time: Fri Dec 09 04:25:49 CST 2016

Total time taken to generate the page: 0.14385 seconds