comma_to_table

From: s Lehaire <s.lehaire_at_meilleuregestion.com>
Date: Fri, 29 Nov 2002 16:47:41 +0100
Message-ID: <as81ep$p5m$1@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 Fri Nov 29 2002 - 09:47:41 CST