Hey Sergy,

Thanks. A UDF did the trick. I had to modify the SP slightly, since it made use of some features that aren't supported in a UDF. But creating a UDF I could call from the View meant absolutely no Java code changes. So a couple hours creating the UDF and I was done!

>See Re: How can I know if a folder exist Message #962432 for example.
>
>>
>>How do you use SP or UDF in an INSERT statement? Would you please provide some samples if it's not too much to ask?
>>
>>Thanks a lot in advance.