Re: Access frontal interface for Oracle database
From: <sybrandb_at_hccnet.nl>
Date: Mon, 11 Aug 2008 00:18:20 +0200
Message-ID: <n6qu94580pm47li5vtqlpa978ascio6g9d@4ax.com>
Date: Mon, 11 Aug 2008 00:18:20 +0200
Message-ID: <n6qu94580pm47li5vtqlpa978ascio6g9d@4ax.com>
On Sun, 10 Aug 2008 16:06:41 +0200, Gloops <gloops_at_invalid.zailes.org>
wrote:
>The Execute method (of ADODB ? not sure I remember, I have a look
>tomorrow) can execute, on Oracle, commands INSERT, DELETE, UPDATE, but
>not EXECUTE, I could not execute a stored procedure in Oracle that way.
It could in the past and I don't see why it can't now. As 'execute' is a sql*plus keyword, and not a SQL keyword, the syntax is { BEGIN <procedure>; END; }
(from memory)
-- Sybrand Bakker Senior Oracle DBAReceived on Sun Aug 10 2008 - 17:18:20 CDT