Hello,

OS - HP-UX 11.x
Oracle - 8.1.7.x

As per Oracle 8i precompiler's guide, there appear to be 2 methods of
calling a stored procedure from Pro*C code.

Method 1 is of the type
EXEC SQL EXECUTE
BEGIN
SP_X(args);
END;
END-EXEC;

Method 2 is of the type
EXEC SQL CALL SP_X(args);

What's the essential difference between these 2 methods? Is it true
that CALL is SQL syntax and hence understands SQL data types only? If
that is correct, what are its' implications on the data types that can
use to pass / retrieve from a stored procedure? If at all one is given
the choice of using either of these methods, which one is recommended
and why?

regards
bhooshan