Hi
I am trying to insert the results of an informix stored procedure into a table. I tried to do
insert into temp_test Execute procedure test()

I get an error- Illegal SQL statement in SPL routine.

I am plugging into a client system where I dont have access to modify any procedures that are built already. I just need the results of what comes back from the procedure to be stored in a temp table so I can run some roll ups on it. Is this possible to do in informix?

Thanks
Jayasri

Hi,

maybe detailing a bit more of your SPL code and the error you get at SPL execution
would help to troubleshoot and provide an solution

A bit difficult to guess without all this.