hi
i wrote a store procedure using the pl/perlU language, and the comportment is strange.
my procedure do a select on my database and some traitments too and write the result in a file;
when i run the procedure a first time, it works fine, the file is create and data are in. but when i run my procedure a second time, the file is create but the data aren't write in it. where is the problem ?
i had an other problem the past week, but i not able to reproduce it. it was a very simple funtion who store a string into a variable and display it on the screen : something like this :
my $toto = '->';
$toto.='titi';
elog NOTICE, $toto;
the problem was : the first time i ran the procedure and i get : ->titi and the second time : ->titititi, etc....
the variable $toto wasn't reinitialize. maybe somebody had the same problem.
(if i have enough time, i will post the code)
thanks in advance
Will