Odd Oracle Error

Question

I'm having a small issue with an Oracle command, given below:

command.CommandText = "SELECT ID, NAME, RATING, LENGTH, STARTTIME FROM SCHEDULE WHERE ID=301 AND ROWNUM=1 AND SCHEDULE.STARTTIME <= SYSDATE ORDER BY STARTTIME DESC;";

It runs perfectly well in Oracle SQL Developer, returning exactly what I need, but in C#, i get the following error:

ORA-06550: line 1, column 186:
PLS-00103: Encountered the symbol "," when expecting one of the following:

. ( * @ % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec as between || indicator multiset member
submultiset

Can anyone see any issues with it, or anything that is illegal within C#?

EDIT: Execution code:

command.Connection = conSQL;
using (IDataReader reader = command.ExecuteReader())
{
    do
    {
        int count = reader.FieldCount;
        while (reader.Read())
        {
            for (int i = 0; i < count; i++)
            {
                 string setting = reader.GetName(i).ToString();
                 object value = reader.GetValue(i);

                 ** Data assigned to variables here, hidden due to length of code**
                 ** Follows pattern: object.property(reader.name) = reader.value **
            }

        }
    } while (reader.NextResult());
 }

There has to be something going weird with the execution code. Please post the rest of the error and the entire snippet of code that's executing the command. — Mike Perrenoud
– Mike Perrenoud, Commented Sep 12, 2012 at 11:42

Michel · Accepted Answer · 2012-09-12 11:43:25Z

2

dot not put ; at the end of the command, that's a command line tool convention, not part of sql proper (sqlplus also uses / as terminator for instance)

answered Sep 12, 2012 at 11:43

Michel

2921 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Mike Perrenoud Over a year ago

And that would cause it to say it encountered a , when parsing the statement?

Bob Jarvis - Слава Україні Over a year ago

@Mike: Oracle's error messages are known to be less than helpful. First thing I thought was "There's probably a trailing semi-colon on the statement" and, yep, there it was.

Mike Perrenoud Over a year ago

@BobJarvis, awesome. And now that the OP posted the rest of the error I have to be honest, my heart sunk seeing that, it hold literally no value.

Bob Jarvis - Слава Україні Over a year ago

@Mike: it's all about trying things and seeing what happens. I still have to believe that the ';' shouldn't be there - perhaps next to try is Skulmuk's idea of quoting the ID and NAME...

Michel Over a year ago

SQL is hard to parse, the syntax was defined at the height of the "natural language" fad, as a consequence locating errors is hard for the parser (Oracle is also notorious for the low quality of the error messages).

|

Slugart · Accepted Answer · 2012-09-12 11:44:17Z

1

Name and Id are both special keywords in Oracle SQL. Try:

SELECT "ID", "NAME"...

answered Sep 12, 2012 at 11:44

Slugart

4,69027 silver badges33 bronze badges

3 Comments

Skulmuk Over a year ago

I've tried this, and combined with Bob's advice, get ORA-00933: SQL command not properly ended

Slugart Over a year ago

Add the ";" back to the statement and make sure that the capitilisation of your columns matches the definition as "ID" is case sensitive.

Vincent Malgrat Over a year ago

This could perhaps have been a problem, but ID and NAME are not reserved words in Oracle (thankfully, since a good portion of database tables have an ID column :)

Bob Jarvis - Слава Україні · Accepted Answer · 2012-09-12 11:44:27Z

1

Remove the trailing semi-colon on the SQL statement.

Share and enjoy.

answered Sep 12, 2012 at 11:44

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

3 Comments

Mike Perrenoud Over a year ago

And that would cause it to say it encountered a , when parsing the statement?

Skulmuk Over a year ago

If I remove the trailing semi-colon, I get ORA-00933: SQL command not properly ended

Bob Jarvis - Слава Україні Over a year ago

@Mike: As I noted below, Oracle's messages are often unhelpful in diagnosing the actual problem. In this case the semi-colon at the end of the statement is the likely culprit.

Collectives™ on Stack Overflow

Odd Oracle Error

3 Answers 3

6 Comments

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related