This is a migrated thread and some comments may be shown as answers.

[Solved] error: ORA-00936: missing expression

1 Answer 177 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Manan
Top achievements
Rank 1
Manan asked on 01 Jun 2009, 05:22 AM
Hey,

I have very recently started to use RAD Controls. I have been trying to implement the RADScheduler control since the past week. After overcoming a variety of errors, I've been stuck on this particular error for the past 2 days. I'm pasting the code where this error is coming.

private

 

IEnumerable<Resource> GetTeachers()

 

{

 

List<Resource> resources = new List<Resource>();

 

 

using (DbConnection conn = OpenConnection())

 

{

 

DbCommand cmd = DbFactory.CreateCommand();

 

cmd.Connection = conn;

cmd.CommandText =

"SELECT [TeacherID], [Name], [Phone] FROM [DbProvider_Teachers]";

 

 

using (DbDataReader reader = cmd.ExecuteReader())

 

{

 

while (reader.Read())

 

{

 

Resource res = new Resource();

 

res.Type =

"Teacher";

 

res.Key = reader[

"TeacherID"];

 

res.Text =

Convert.ToString(reader["Name"]);

 

res.Attributes[

"Phone"] = Convert.ToString(reader["Phone"]);

 

resources.Add(res);

}

}

}

 

return resources;

 

}

The error disappears when I comment and run the program but obviously i am not able to use this functionality then. Please help asap.

Thank you,

Manan Podar

1 Answer, 1 is accepted

Sort by
0
Atanas Korchev
Telerik team
answered on 01 Jun 2009, 07:44 AM
Hello Manan,

This seems to be an Oracle error. Since we are not Oracle experts we won't be able to assist.

Regards,
Albert
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
Scheduler
Asked by
Manan
Top achievements
Rank 1
Answers by
Atanas Korchev
Telerik team
Share this question
or