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

It's an Oracle error, you need to post the Oracle procedure code for us to debug it.

Hello,
I have a similar problem if anyone can please help:

Error
-----

System.Data.OleDb.OleDbException was caught
  Message="ORA-06550: line 1, column 83:\nPLS-00103: Encountered the symbol \")\" when expecting one of the following:\n\n ( - + case mod new not null others <an identifier>\n <a double-quoted delimited-identifier> <a bind variable> avg\n count current exists max min prior sql stddev sum variance\n execute forall merge time timestamp interval date\n <a string literal with character set specification>\n <a number> <a single-quoted SQL string> pipe\n <an alternatively-quoted string literal with character set specification>\n <an alternatively-q"
  Source="Microsoft OLE DB Provider for Oracle"
  ErrorCode=-2147217900
  StackTrace:
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
       at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute NonQuery(OleDbConnection connection, CommandType commandType, String commandText, OleDbParameter[] commandParameters) in C:\Documents and Settings\Administrator\Desktop\awni\oledb\oledb\V3 \CSSCommServer\CSSCommServer\CSSCommServer\SqlHelp er.cs:line 336
       at CSSTrackWell.CJDataBase.Insert(String szSPName, OleDbParameter[] arParms) in C:\Documents and Settings\Administrator\Desktop\awni\oledb\oledb\V3 \CSSCommServer\CSSCommServer\CSSCommServer\CJDataB ase.cs:line 252



Proc
----


CREATE OR REPLACE PROCEDURE InsertGPRMC
(
    IMEI IN CHAR DEFAULT NULL,
    chCarLicensePlate IN CHAR DEFAULT NULL,
    Date_Time IN timestamp DEFAULT NULL,
    Lon IN float DEFAULT NULL,
    Lat IN float DEFAULT NULL,
    Speed IN float DEFAULT NULL,
    Direction IN float DEFAULT NULL,
    Status IN CHAR DEFAULT NULL,
    ID IN char
)
AS
BEGIN

    INSERT INTO GPRMC
            ( IMEI ,
            CarLicencePlate ,
            Date_Time ,
            Lon ,
            Lat ,
            Speed ,
            Direction ,
            Status,
 ID )
     VALUES ( InsertGPRMC.IMEI ,
            InsertGPRMC.chCarLicensePlate ,
            InsertGPRMC.Date_Time ,
            InsertGPRMC.Lon ,
            InsertGPRMC.Lat ,
            InsertGPRMC.Speed ,
            InsertGPRMC.Direction ,
            InsertGPRMC.Status,
InsertGPRMC.ID );



END;
/