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
|