Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Insert results of execute procedure into a table

    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

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •