Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how can I correct this ?
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:18:25 CST