Subject calling stored procedure from embedded sql
Author cdelaune2001
How is it done?

I attempt the following call:

EXEC SQL EXECUTE PROCEDURE FOO;

(Actually DB1.FOO because the procompiler complains that FOO is
ambiguous.)

The statement precompiles and compiles, but bombs on execution.