Re: Store procedure in Pro*C

From: John Verbil <jverbil_at_netmail.mnet.uswest.com>
Date: 1996/12/20
Message-ID: <32BB1E5F.28AE@netmail.mnet.uswest.com>#1/1

aoviedo_at_cool.co.cr wrote:
>
> Somebody have the sintaxis to call a
> store procedure or function from Pro C ???
>
> I try with
>
> EXEC SQL EXECUTE THE_PROCEDURE USING :parameter1, :parameter2;
>
> but i get an error ORA-01001: invalid cursor...
>
> some idea or hint ?
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

EXEC SQL EXECUTE

	BEGIN
		THE_PROCEDURE(:parameter1, :parameter2);
	END;

END-EXEC;

-- 
John Verbil
U S WEST Communications
Information Technologies
jverbil_at_uswest.com
(303) 896-0916

Received on Fri Dec 20 1996 - 00:00:00 CST