Re: Stored Procedure question
Date: Mon, 06 Jul 1998 15:30:21 GMT
Message-ID: <6nqqid$ovs$1_at_nnrp1.dejanews.com>
Try using a call statement and single quotes around parm1 set recset = connection.execute("call spname('parm1', 2, 1998)")
In article <6nct80$uah$1_at_reader1.reader.news.ozemail.net>,
"Simon Kerr" <kerrsim_at_ozemail.com.au> wrote:
>
> Hi All,
> I am trying to run an Oracle Stored procedure (that works fine using SQL
> Plus) using an ASP Page (ADODB) the command should be something like
>
> set recset = connection.execute("execute spname("parm1", 2, 1998)
>
> but I get a funny error when I run it (I have forgotten what) something like
> invalid parameter...
>
> If anyone has any experience with this, I would love some help!!
>
> Thanks, Simon
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 06 1998 - 17:30:21 CEST