OraFAQ Forum: Windows » ORA-03001 error

Home » Infrastructure » Windows » ORA-03001 error

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-03001 error [message #332669]

Wed, 09 July 2008 06:01

varun_mca_ju
Messages: 2
Registered: July 2008

Junior Member

I have a textbox called "txtPurpose" in a C# Windows Application, and i want that the text entered by the user in the textbox should be added to the "PURPOSE" field in a table "TABLE2_HDB1" in Oracle database "HDB1" on clicking a "submit" button.
i am passing textbox value to function Insert like
Insert(txtPurpose.Text);

private bool Insert(string field)
{
bool success = false;

string constr = "Provider=MSDAORA;Data Source=HDb1;User Id=myUsername;Password=****;";
OleDbConnection con = new OleDbConnection(constr);
try
{ con.Open();
OleDbCommand sc = new OleDbCommand("insert into TABLE2_HDB1 (PURPOSE) values '" + field + "'", con);
sc.CommandType = CommandType.Text;
if (sc.ExecuteNonQuery() > 0) success = true;
}
catch (OleDbException sq)
{
MessageBox.Show("Error : " + sq.Message);
}
finally
{
if (con.State != ConnectionState.Closed) { con.Close(); }
con.Dispose();
}
return success;
}
on running this code i get the error ORA-03001:unimplemented feature....plz help Sad

Report message to a moderator

Re: ORA-03001 error [message #332682 is a reply to message #332669]

Wed, 09 July 2008 06:30

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Read the OraFAQ Forum Guide before posting.

Quote:

ORA-03001: unimplemented feature
Cause: This feature is not implemented.
Action: None.

Report message to a moderator

Re: ORA-03001 error [message #332685 is a reply to message #332669]

Wed, 09 July 2008 06:34

Michel Cadot
Messages: 54251
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Print the command before executing it and post it.
I bet you have a not correct statement.

Regards
Michel

Report message to a moderator

ORA-00936:missing expression [message #333972 is a reply to message #332685]

Tue, 15 July 2008 01:40

varun_mca_ju
Messages: 2
Registered: July 2008

Junior Member

thanks for the help Talpush and Michel....i am now using a different code and having the following problrm....

I have a textbox called "txtPurpose" in a C# Windows Application, and i want that the text entered by the user in the textbox should be added to the "PURPOSE" field in a table "TABLE2_HDB1" in Oracle database "HDB1" on clicking a "submit" button.
the coding for the submit button is as follows :-

private void button1_Click(object sender, EventArgs e)
{
string OracleStmt;
string ConString;
OleDbConnection cn = null;
OleDbCommand cmd = null;
try
{
OracleStmt = "insert into TABLE2_HDB1(PURPOSE) values(@PURPOSE)";
ConString = " Provider=MSDAORA;Data Source=HDb1;User Id=SYSTEM ;Password=*****;";
cn = new OleDbConnection(ConString);
cmd = new OleDbCommand(OracleStmt, cn);

cmd.Parameters.Add(new OleDbParameter("@PURPOSE", OleDbType.VarChar , 20));
cmd.Parameters["@PURPOSE"].Value = txtPurpose.Text;
cn.Open();

cmd.ExecuteNonQuery();
textBox8 .Text = "record inserted successfully";
}
catch (Exception ex)
{
textBox8 .Text = ex.Message;
}
finally
{
cn.Close();
}
}

on executing the code i am getting the error :-
ORA-00936:missing expression.
please help.

Report message to a moderator

Re: ORA-00936:missing expression [message #333983 is a reply to message #333972]

Tue, 15 July 2008 02:01

Michel Cadot
Messages: 54251
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Your statement is not correct.
We don't have your statement, we can't say more.
Do as I said: print your statement before sending it to Oracle.

Regards
Michel

Report message to a moderator

Previous Topic:	Need help with Installation of Oracle 11g release 1 on Vista Business
Next Topic:	Make server send text message or email when service dies?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 26 01:21:10 CDT 2013

Total time taken to generate the page: 0.15422 seconds