ODBC error running Oracle 7.3 stored procedures

[colly9]

Hello everybody. ANy help with this would be appreciated !

Opening oracle connection thus:
SQL_CN2.Open "Provider=MSDAORA.1;Data Source=pimsproduction;User ID={ID};Password={PWD}"

strSqlStatement = "execute test_proc"

Set Comm = Server.CreateObject("ADODB.Command&quot
Set comm.ActiveConnection = SQL_CN2
Comm.CommandType = adCmdStoredProc
Comm.commandtext = strSqlStatement
Comm.execute


"test_proc" is a simple procedure that does returns no data, and has no parameters, and works OK in SQL*Plus, but from the above ASP code I get:

Microsoft OLE DB Provider for Oracle error '80040e14'
Syntax error in {call...} ODBC Escape.

I am completely stuck ! Is it the way I am opening the connection ?

Any help appreciated !

Iain

 

[TechnicalAnalysis]

For ORACLE connection by ASP,
set dbconn = server.CreateObject("ADODB.Connection&quot
dbconn.Open "Provider=MSDAORA.1;Data Source=sun1.xxxxxxx.com;User
Id=xxxxxt;PASSWORD=xxxxxxx;"