Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 19th, 2004, 07:15 AM
Registered User
 
Join Date: Aug 2004
Location: , , .
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





 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:51 PM.


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