What is the difference between EXEC SQL CALL vs. EXEC SQL EXECUTE

From: Bhooshan S. Prabhu <bhooshanprabhu_at_indiatimes.com>
Date: 10 Dec 2002 01:27:03 -0800
Message-ID: <e9d6edea.0212100127.4c189718@posting.google.com>

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_XXXX(args);
  END;
  END-EXEC; Method 2 is of the type
  EXEC SQL CALL SP_XXXX(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 Received on Tue Dec 10 2002 - 03:27:03 CST

What is the difference between EXEC SQL CALL vs. EXEC SQL EXECUTE - BEGIN/END