Re: OCI: how to execute a procedure ??

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Fri, 13 Feb 2004 11:07:14 +0000
Message-ID: <Z0l2VdAi$KLARxKi@peterfinnigan.demon.co.uk>

Hi Andre

It won't work because "execute" is a SQL*Plus command not a PL/SQL command. To execute PL/SQL from OCI you need to include your command in an anonymous block such as

begin;myprocedure(somearg);end;

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Fri Feb 13 2004 - 05:07:14 CST