Focal Point
Fetch in Oracle Procedure

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7331044791

November 20, 2006, 01:07 PM
CHERI
Fetch in Oracle Procedure
We are using WF 5.23 - I have many Oracle procedures running via the WF tool. We use
SQL SQLORA EX procedure_name;
these procedures are fine. I having trouble with an Oracle procedure I'm trying to call via the WF tool. The Oracle procedure is using a FETCH within it. Does anyone know if FETCH is supported with the WF tool ?
November 20, 2006, 01:53 PM
gregson06
Not sure if FETCH is allowed, however supposedly there is a list of processes that translate to the database, even if you are using a Pass through. Have you tried contacting technical support on it? It may be something that just isn't possible through the FOCUS side.