Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle 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:24 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


 
Old January 27th, 2005, 08:27 AM
Authorized User
 
Join Date: May 2004
Posts: 28
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

 
Old November 5th, 2008, 06:49 AM
Registered User
 
Join Date: Nov 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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;
/








Similar Threads
Thread Thread Starter Forum Replies Last Post
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
Oracle error '80040e14' Nitin_sharma Oracle ASP 0 January 25th, 2005 08:11 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.