Re: how can I correct this ?

From: s Lehaire <s.lehaire_at_meilleuregestion.com>
Date: Mon, 2 Dec 2002 10:29:30 +0100
Message-ID: <asf8ed$t2v$1@reader1.imaginet.fr>

Thx for No response I find how to correct this : For integer we have to put values between double quotes ("1"); for empty values we have to put a string like EMPTY because "" doesn't work .

"s Lehaire" <s.lehaire_at_meilleuregestion.com> a écrit dans le message de news: as7vnt$omk$1_at_reader1.imaginet.fr...
> Hi !
> I'm trying to use COMMA_TO_TABLE procedure but i've got a little problem.
> When I write COMMA_TO_TABLE('a,b,c,d',len,tab) it's ok but when I write
>
> COMMA_TO_TABLE(fileout,len,tab)
> where fileout = '1,0,PERIODE,MATR,NOM,PRENOM,HESU_110,HESU_125,SALA_BASE'
>
> I've got an ORA-000932 error but when my string haven't got integer
there's
> no problem.
>
> I've tried to put all value between simple quotes :=
> '1,'0','PERIODE','MATR','NOM','PRENOM','HESU_110','HESU_125','SALA_BASE'
> but the probleme is still there
>
> So how can I get a string containing integers into an array ?
>
> thx for help =)
>
>
Received on Mon Dec 02 2002 - 03:29:30 CST