Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Database Errors Interview Questions
Questions Answers Views Company eMail

PCC-02439: FOR clause not allowed in this COLLECTION statement

1 2938

PCC-02440: This attribute is valid for either internal or external LOBs

1 2916

PCC-02441: Number of attributes does not match number of host variables

1 2963

PCC-02442: Expecting a value between 1 and 65535 inclusive

1 3422

PCC-02443: This usage is only valid when DYNAMIC=ANSI is specified

1 5846

PCC-02444: Invalid combination of descriptor and non-descriptor clauses

1 2624

PCC-02445: USING clause valid only on a PREPAREd dynamic statement

1 2871

PCC-02446: FOR clause not allowed in a DEALLOCATE statement

1 3173

PCC-02447: Cannot specify destination offset in a LOB WRITE APPEND

1 3159

PCC-02448: Cannot specify a UCS2 variable in the NLS_NCHAR option

1 3166

PCC-02449: Cannot type equivalence a UCS2 type

1 2725

PCC-02450: Cursor was not declared in scrollable mode

1 2840

PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode

1 2877

PCC-00001: Unable to open file string

1 3166

PCC-00002: Invalid syntax at column number in line number of file string

1 2864


Un-Answered Questions { Database Errors }

RMAN-05017: no copy of datafile number found to recover

2470


I have written the code as below. here problem is that dt remain null. how to solve thst please tell me. public partial class Form1 : Form { private DataTable DTable; private DataRow drow; public Form1() { InitializeComponent(); } private OleDbConnection getConnection() { OleDbConnection con=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\winApp for Student\winApp for Student\App_Data\SchooMgnSystem.mdb;Persist Security Info=True"); return con; } private void button1_Click(object sender, EventArgs e) { InsertData(); } private void InsertData() { if (DTable==null) { DTable = new DataTable(); DTable.Columns.Add("StudID", typeof(string)); DTable.Columns.Add("StudName", typeof (string)); DTable.Columns.Add("Address", typeof(string)); drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } else { drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } } private void button2_Click(object sender, EventArgs e) { string cmdstr; OleDbCommand cmd; OleDbConnection con = getConnection(); foreach (DataRow Drow in DTable.Rows) { cmdstr = "Insert into Student values('" + drow[0].ToString() + "','" + drow[1].ToString() + "','"+drow [2].ToString()+"')"; cmd = new OleDbCommand(cmdstr,con); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } } }

2715


ORA-16516: The current state is invalid for the attempted operation.

8881


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2803


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2786


java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6721


IMP-00070: Lob definitions in dump file are inconsistent with database.

1801


When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2586


ORA-26095: unprocessed stream data exists

3642


How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2701


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2948


How to view the error log for any specific instance?

2544


ORA-16626: failed to enable specified object

2278


NZE-28890: Entrust Login Failed

1932


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3440