I hae following codes:

SQL

SELECT MYFUNCTION(URL)
FROM USER_DETAIL;

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HOLD1
END

If without "ON TABLE HOLD AS HOLD1", it works fine. However, with ON TABLE HOLD AS HOLD1, I got (FOC1571) SET SERVER xxxx COMMAND FOR ORACLE INTERFACE OUT OF SEQUENCE. MYFUNCTION is a function created on Oracle.

Thank you to let me know what I did wrong.

This message has been edited. Last edited by: EdHou,

quote:

with ON TABLE HOLD AS HOLD1, I got (FOC1571) SET SERVER xxxx COMMAND

That's not the right syntax. Try:

SQL SQLORA

SELECT MYFUNCTION(URL) 
FROM USER_DETAIL;

TABLE ON TABLE HOLD AS HOLD1
END

TABLE FILE HOLD1
PRINT *
END

Thank you so much, it's working.