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 August 19th, 2004, 07:15 AM
Registered User
 
Join Date: Aug 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sandeepshivathaya
Default Need help to Resolve Error ORA-00933



Hi,



I am Sandeep working in Iflexsolutions

When searching internet to get the solution for the error ORA-00933 I found you are also faced this error.

I have got a problem.

I am using ORACLE at backend and VB.NET at front end.

I am executing following SQL

Select REF_NO, CHANGE_TYPE, CODE, CONSEQ from TB_MASTER

where OBJECT_TYPE='TABLE' and OBJECT_NAME='TABLE2' and PROJECTNAME='SANDEEP'

and relname='FCC' order by SUBSTR(REF_NO,2,1) DESC, REF_NO ASC



I am using following code in front end

Dim Connect As New OracleConnection()

            Dim Comm As New OracleCommand()

            Dim DAdapter As New OracleDataAdapter()

            Dim RowCounter As Integer = 0

            Dim param1, Param2, Param3, Param4, Param5, Param6 As OracleParameter

            Dim i As Object

            Dim Dr As OracleDataReader

            Dim Rs As New DataSet()

            Dim Rs1 As New DataSet()



            Comm.CommandText = _

                            " Select REF_NO, CHANGE_TYPE, CODE, CONSEQ from TB_MASTER " & _

                            " where OBJECT_TYPE = '" & p_type & "' and OBJECT_NAME = '" & _

                            l_objname & "' and PROJECTNAME = '" & p_projname & "' and relname = '" & _

                            p_relname & "' order by SUBSTR(REF_NO,2,1) DESC, REF_NO ASC "

                        Comm.Connection = Connect

                        Comm.Prepare()

                        DAdapter.SelectCommand = Comm

                        DAdapter.Fill(Rs1)



Line DAdapter.Fill(Rs1) Corresponds to 400 Line.



Here is the error I am getting



CoreLab.Oracle.OracleException: ORA-06550: line 2, column 209:

PL/SQL: ORA-00933: SQL command not properly ended

ORA-06550: line 2, column 4:

PL/SQL: SQL Statement ignored

   at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, Int32 A_1, Boolean A_2, Int32 A_3, Int32 A_4, Int32& A_5)

   at CoreLab.Oracle.OracleCommand.ExecuteReader(Command Behavior behavior)

   at CoreLab.Oracle.OracleCommand.c(CommandBehavior A_0)

   at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at Flexmart.Flexmart.ClsFlex.fn_call_conv(String p_path, String p_projname, String p_relname, String p_type, String conn) in D:\Flexmart\Flexmart_VB\Flexmart.NET Uaing ODBC\Flexmart.vb:line 400





Can I get any help regarding this.



Thanks in Advance.

Regards,

Sandeep










Similar Threads
Thread Thread Starter Forum Replies Last Post
How to resolve #Name? Error problem in few fields jack123 Access 1 August 2nd, 2007 02:08 PM
[Oracle][ODBC][Ora][ORA-01013 Corey Access 1 December 15th, 2006 10:29 AM
Ora-01034 error jfrank7992@aol.com Oracle 5 September 30th, 2004 08:40 PM
Encounter ORA-00933 when use RETURN_GENERATED_KEYS ykchua Java Databases 0 August 10th, 2004 05:38 AM
Error-cannot resolve symbol Rusk JSP Basics 1 February 18th, 2004 09:20 AM





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