Re: Example ADO function

"Pile" <philipwinfield_at_totalise.co.uk> wrote in message news:f2fcb581.0306200136.554f6fcd_at_posting.google.com...
> Rebro <rebro_at_mail.net.mk> wrote in message
news:<d0ptevod95c643tsk3dmvqt9ooltd7aeup_at_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
>
> Rebro
> Thanks so much for posting this - this is what I am after and I
> suspect it is almost there now, however I get the following error. Any
> additional ideas welcome before I ditch ADO in favor of ))4).
> Phil

I'd suggest turning off friendly errors in I.E so that you get the actual error the page is throwing rather than the generic 500 error page that ie produces. This will give you an error message which whilst it may be 'unfriendly' will actually tell you what is going on. In the absence of a proper error message though I'd advise you to check wether the anonymous internet account has read/execute permissions on the ORACLE_HOME directory.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK