Re: Stored procedure from Pro*C

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1996/09/27
Message-ID: <52h38i$cuf_at_inet-nntp-gw-1.us.oracle.com>#1/1

In article <52f4p5$6ef_at_lll-winken.llnl.gov>, busch1_at_llnl.gov writes:
|> What is the correct syntax for calling a stored procedure from a
|> Pro*C program?
|>
|> The following compiles but gets an error at runtime:

Um... what error do you get? This syntax looks fine. Make sure that procedure_name actually exists and that the user to which you connect has execute privileges on it.

|>
|> EXEC SQL EXECUTE
|>
|> declare
|> ....
|> begin
|> procedure_name(param1, param2, param3);
|> end;
|>
|> END-EXEC;
|>
|>
|> ---
|> Jeff Busch Internet busch1_at_llnl.gov
|> Voice (510) 423-9134 Fax (408) 263-1360
|>
|>

---

Scott Urman Oracle Corporation surman_at_us.oracle.com

---

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

---

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"

---

Received on Fri Sep 27 1996 - 00:00:00 CEST