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