Oracle 7.3 + ASP/ADO not running a stored procedure (error '80040e14' )

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")
  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





---------------------------------
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].