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