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

for calling a procedure using ADO you should use the syntax {call [Procedure]}
instead of your syntax : execute ...

make the command type sqlcommand

Hope this helps ..

x

------------------------
 "Oracle" <[email protected]> wrote:
------------------------
	
>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.unsub%%.
>



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