Re: Problem executing Oracle SP from ASP page
- From: dave_93_98@xxxxxxxxx
- Date: 18 Jul 2005 06:30:27 -0700
Thanks for the responses Val and Daniel,
I was able to resolve this last week by changing the commandtext
property to not include any place holders -
..CommandText = "MECC_Pivot.PivotSteps"
Dave
dave_93_98@xxxxxxxxx wrote:
> Hello,
> I am receiving the following error when I try to execute an Oracle
> procedure (within a package) that returns a ref cursor from an ASP
> page. The error message is -
>
> Syntax error in {call...} ODBC Escape
>
> By the way the code works fine from a VB6 application it only fails
> when executed as an asp page so I don't believe the syntax is
> incorrect. Here is the relevant code -
>
> cnAdo.Provider = "MSDAORA"
> cnAdo.ConnectionString = "...;PLSQLR-Set=1;"
> cnAdo.Open
> cmdAdo.ActiveConnection = cnAdo
> cmdAdo.CommandType = adCmdStoredProc
> cmdAdo.CommandText = "{CALL MECC_PIVOT.PivotSteps(?, ?)}"
> cmdAdo.Parameters.Append cmdAdo.CreateParameter("vLOTID", adVarChar,
> adParamInput, 40, "E0025659")
> cmdAdo.Parameters.Append cmdAdo.CreateParameter("pErrCode",
> adVarNumeric, adParamOutput, 10)
> Set rsAdoDemo = cmdAdo.Execute
>
>
> I do have Oracle 8.1.7 and Oracle 9.2 clients installed on this
> machine.
>
> Thanks,
> Dave
.
- References:
- Problem executing Oracle SP from ASP page
- From: dave_93_98
- Problem executing Oracle SP from ASP page
- Prev by Date: Is MSLDBUSR.DLL be distributed with a retail app?
- Next by Date: ADO connectiosn & recordsets
- Previous by thread: Re: Problem executing Oracle SP from ASP page
- Next by thread: FileSystemWatcher for SQL
- Index(es):
Relevant Pages
|
