Re: Help: Calling stored procedure from Impromptu using OLE Automation

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/10/28
Message-ID: <01bce36f$06790240$f3040059@billyv.vslabs.co.za>#1/1

Alexander Kravchenko <akravchenko_at_bny18.bloomberg.com> wrote in article <344F6B46.78A609AA_at_bny18.bloomberg.com>...
> Hi,
> I wonder if somebody had a similar problem. I have a stored procedure
> that executes fine in sqlplus. But when I try to execute it on the
> client side in an Impromptu macro it gives me ole automation error. I
> wonder if somebody else experienced similar problems using Cognos tools.
<snip>
> impSp.setProcedure "sqltest(in, in out)"

Try:

impSp.setProcedure "begin sqltest(in, in out); end;"

Hope it works! :-)

regards,
Billy Received on Tue Oct 28 1997 - 00:00:00 CST