Type - Model: 9406 - 520
i5/OS version:  5 Release 4 Modification 0

I need to be able to create a script that will allow me to store the
results of a stored proc into a session temp table. I need to be able
to do this in a script, not a stored procedure.

Something like this:

SELECT INTO Session.TempTable (CALL MyProc('12345'));
SELECT * FROM Session.TempTable WHERE Column1 = 'A';

MyProc already exists and I don't have the luxury of modifying it in
any way. Is this possible?