Re: Example ADO function

From: Rebro <rebro_at_mail.net.mk>
Date: Tue, 17 Jun 2003 12:00:38 +0200
Message-ID: <d0ptevod95c643tsk3dmvqt9ooltd7aeup@4ax.com>

>Thanks Steve, yes I have seen this but this did not work either. And
>Jim, thanks for your helpful observation of the error message. Yes, it
>was obvious so I upgraded to the 9.2.0.4 version of the Oracle ODBC
>driver - if you know of another that will work or an alternative code
>approach that might be useful.

As I understood you need to call Oracle stored function from ASP. You can try this...

I think you can manage :-)

Set konekcija = Server.CreateObject("ADODB.Connection") konekcija.Open "Provider=MSDAORA.1;Data Source=oracle_sid;Persist Security Info=True","username","password" Set cmdobject = Server.CreateObject("ADODB.Command") sql = "{?= call package1.function1(?,?,?)}" With cmdobject

        Set .ActiveConnection = konekcija
   .CommandText = sql
   .CommandType = adCmdText

	.Parameters(1).Value = Request.Form("param1")
	.Parameters(2).Value = Request.Form("param2")
	.Parameters(3).Value = Request.Form("param3")

   .Execute()
End With
With cmdobject

        function_result = .Parameters(0)
End With
cmdobject.close
konekcija.close
set cmdobject=nothing
set konekcija=nothing

-- 
Ребро

Received on Tue Jun 17 2003 - 05:00:38 CDT