trigger a stored proc from ASP

From: John Timney <timneyj_at_syntegra.bt.co.uk>
Date: Tue, 29 Sep 1998 16:33:20 +0100
Message-ID: <6uqv2j$oij$1@pheidippides.axion.bt.co.uk>

Can anyone tell me the syntax for triggering a stoired procedure from asp to an Oracle 7 database from Active Service Pages using an ADO connection object and ODBC.

I'm familiar with the SQLServer version, but Im led to believe that the Oracle version is different, and is not the same as issuing the statement from SQLPlus.

This is what I've tried.

Set dbConnection = Server.CreateObject("ADODB.Connection") dbConnection.Open "DSN=mydsn;UID=fred;PWD=password;" '# execute the stored proceure
dbConnection.execute "begin john.john("1998","TEST1"); end;"

The string is being formatted in a slightly diferent manner, what is passed though is what is shown above.

If anyone can suggest anything or give me an example using the oracle objects instead, I would appreciate it.

John Timney Received on Tue Sep 29 1998 - 10:33:20 CDT