Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle ASP
|
Oracle ASP Using ASP with Oracle databases. For Oracle discussions not specific to ASP, please see the Oracle forum. For more ASP discussions, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 25th, 2005, 08:11 AM
Authorized User
 
Join Date: Sep 2004
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Nitin_sharma Send a message via Yahoo to Nitin_sharma
Default Oracle error '80040e14'

Hi Guys,

Today I was trying to access the store procedure i come across
an error which is given below :

Microsoft OLE DB Provider for Oracle error '80040e14'

ORA-06550: line 1, column 83: PLS-00103: Encountered the symbol ">" when expecting one of the following: . ( ) , * @ % & = - + < / > at in is mod not rem <an exponent (**)> <> or != or ~= >= <= <> and or like between ||

/hmis/NITIN/asp_files/showexcelsheets.asp, line 150

And the code is below :

sys_uid = Request.QueryString("sys_uid")
call open_db_connection()
set dbCmd = Server.CreateObject("ADODB.COMMAND")
SET rsStrsurvey =Server.CreateObject("ADODB.RECORDSET")
Const getstructdetails = "{call

HMIS_REPORT_Pkg.Return_Structure_with_survey(?, {resultset 10000, OUT_STRUCTURE_CODE,OUT_STRUCTURE_NAME,OUT_STRUCTUR E_ADDRESS1,OUT_STRUCTURE_ADDRESS2,OUT_STRUCTURE_AD DRESS3,OUT_STRUCTURE_ADDRESS4 ,OUT_STRUCTURE_POSTCODE,OUT_EXCLUSION_AREA1,OUT_EX CLUSION_AREA2,OUT_EXCLUSION_AREA3,OUT_EXCLUSION_AR EA4} )}"

dbCmd.ActiveConnection = con
dbCmd.CommandText = getstructdetails
dbCmd.CommandType = adCmdText
dbCmd.Parameters(0).direction = adParamInput
dbCmd.Parameters(0).Value = sys_uid
SET rsStrsurvey = dbCmd.Execute

the error is comes the last execute line.

Any kind of help would be really appreciated.

Regards,

Nitin







Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle error '80040e14' Nitin_sharma Oracle 2 November 5th, 2008 06:49 AM
ODBC Drivers error '80040e14' kucker6 Classic ASP Databases 2 June 1st, 2006 01:06 PM
IIS 6 error 80040e14 Walkabouttigger Access ASP 0 August 8th, 2005 03:08 AM
error '80040e14' Syntex error in From clause alisonchase Access ASP 5 January 2nd, 2005 10:56 AM
error '80040e14'... only for some not all!?? dancrocker Classic ASP Databases 18 June 10th, 2004 11:15 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.