J'ai un fichier texte qui contient des données, séparées par des tabulations. Lorsque j'essaye des les insérer avec "Oracle8 Navigator", j'ai un message d'erreur :"ORA-01704 constante de chaîne trop longue".
J'essaye de lire le fichier avec php avec ce script:
?
$fp = fopen ("REGIONS2.txt","r" );
while ($donnee = fscanf ($fp, "%s\t%s\t%s\t%s\t%s\t%s\n" )) {
list ($num, $name, $type, $dept, $coord, $centre) = $donnee;
$chaine="$num , $name , $type , $dept , ".strlen($coord)." , $centre";
echo $chaine;
}
fclose($fp);
?>
Mais l'affichage ne corrspond pas à ce que j'ai dans le fichier!
Est-ce aussi du à la longueur?
J'ai essayé d'insérer un n-uplet via php et j'ai le même message!
Pourtant tous les champs font moins de 2000 characters sauf le 4ème que j'ai mis en long comme type et ça va jusqu'a 32776 et j'ai pas autant!
Voici l'insertion que j'ai essayé:
$queryauto="insert into REGIONS values('1','3','1','AIN','079,120053,4000
79,210053,590079,130053,660079,130053,730079,06005
3,740079,050053,780079,120053,830079,410053,930079
,550053,980079,660054,110079,570054,240079,670054,
350079,640054,460079,860054,590079,870054,650079,8
70054,860079,880054,900079,940054,900079,990054,49
0080,050054,490080,140054,790080,340054,730080,420
054,810080,350055,100080,320055,260080,460055,3600
80,640055,320080,720055,360080,970055,290081,07005
5,140081,120055,090081,140055,030081,310055,040081
,440054,880081,450054,790081,490054,630081,640054,
590081,660054,540081,700054,480081,740054,500081,7
70054,580081,760054,690081,890054,670082,040054,73
0082,040054,810082,290054,840082,330055,100082,300
055,150082,420055,330082,490055,270082,690055,2800
83,090055,310083,160055,330083,330055,300083,41005
5,210083,460055,230083,490055,260083,680055,040083
,760055,050083,920054,690084,040054,740084,260054,
280084,370054,070084,550053,990084,730053,760084,8
30053,620084,890053,510085,210053,600085,610053,91
0085,730053,910085,760053,990085,640054,280085,510
054,380085,440054,560085,410054,700085,420054,8400
85,290054,950085,370055,170085,450055,330085,28005
5,480085,180055,410084,990055,480084,900055,590084
,840055,540084,760055,520084,660055,550084,490055,
770084,290055,780084,250055,970084,470056,080084,5
10056,180084,390056,280084,330056,430084,290056,59
0084,310056,640084,210056,720084,070056,730083,910
056,730083,870056,830083,780056,840083,740056,9200
83,700056,960083,720057,230083,570057,260083,47005
7,190083,340057,070083,210057,080083,220057,230083
,130057,350083,110057,540083,150057,610083,110057,
760083,150057,880083,110058,030083,160058,140083,1
40058,290083,200058,360083,260058,440083,370058,49
0083,370058,610083,370058,850083,320058,930083,300
058,950083,320059,280083,270059,590083,250059,7900
83,190059,940083,130060,180083,040060,220083,06006
0,480083,050060,670083,030060,770083,070061,080082
,960061,120083,000061,290082,860061,500082,680061,
460082,610061,510082,450061,480082,460061,610082,5
10061,780082,320061,990082,340062,120082,370062,21
0082,340062,250082,110062,330082,060062,380082,000
062,540081,910062,580081,850062,480081,810062,4500
81,740062,230081,590061,990081,390061,960081,25006
1,850081,270061,680081,350061,690081,410061,790081
,460061,680081,330061,610081,290061,520081,260061,
490081,090061,480081,050061,390081,000061,330080,8
70061,160080,680060,970080,610060,930080,540060,82
0080,460060,690080,370060,610080,230060,510080,260
060,340080,350060,240080,280060,210080,200060,1400
80,170060,010080,060059,940079,890059,790079,74005
9,680079,560059,690079,540059,790079,390059,900079
,280060,080079,210060,440079,070060,740078,960060,
790078,860060,890078,850060,890078,730060,960078,5
40060,960078,420060,940078,410060,850078,330060,71
0078,080060,590077,920060,510077,740060,510077,670
060,510077,410060,560077,220060,540077,080060,6400
77,010060,580076,910060,620076,800060,650076,79006
0,650076,700060,670076,560060,600076,370060,680076
,310060,650076,350060,310076,310060,160076,180060,
080076,210059,870076,060059,830076,010059,640075,9
40059,650075,940059,560075,780059,510075,410059,65
0075,460059,490075,450059,380075,290059,340075,220
059,240075,090059,200075,040059,240074,940059,2100
74,820059,190074,810059,060074,960058,960074,97005
8,910074,990058,730074,960058,610074,920058,490074
,920058,480074,920058,210074,920058,130074,870057,
980075,010057,860075,020057,760074,880057,560075,0
10057,410075,030057,330075,090057,220075,210057,06
0075,220057,060075,290056,980075,320056,760075,210
056,690075,150056,590075,120056,550075,240056,2300
75,250056,090075,260055,990075,280055,970075,34005
5,690075,410055,580075,450055,440075,510055,180075
,590055,000075,630054,880075,650054,870075,640054,
680075,620054,580075,710054,380075,760054,330075,7
90054,230075,880054,020075,900054,010075,910053,86
0075,920053,740075,910053,710075,920053,550075,950
053,550076,090053,360076,090053,140076,080053,1300
76,110053,000076,160052,930076,200052,880076,22005
2,740076,310052,760076,310052,830076,390052,840076
,570052,740076,800052,790076,840052,910077,130053,
070077,240053,030077,440052,910077,510052,930077,5
70052,950077,740052,850077,760052,740077,970052,78
0078,000052,660078,270052,780078,290053,000078,380
053,190078,500053,210078,540053,310078,640053,2900
78,870053,410079,030053,360079,120053,400','0,46
8807340,475277')";
Merci de votre aide 
