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

ORA-22913: must specify table name for nested table column or attribute

ABC,

1 9354

ORA-22914: DROP of nested tables not supported

1 8728

ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns

1 4006

ORA-22916: cannot do an exact FETCH on a query with Nested cursors

1 3821

ORA-22917: use VARRAY to define the storage clause for this column or attribute

1 6373

ORA-22918: specified column or attribute is not a VARRAY type

1 3203

ORA-22919: dangling REF error or lock object failed for no wait request

1 3452

ORA-22920: row containing the LOB value is not locked

1 8144

ORA-22921: length of input buffer is smaller than amount requested

1 4416

ORA-22922: nonexistent LOB value

1 9956

ORA-22923: amount of data specified in streaming LOB write is 0

1 5949

ORA-22924: snapshot too old

1 5449

ORA-22925: operation would exceed maximum size allowed for a LOB value

1 3942

ORA-22926: specified trim length is greater than current LOB value's length

1 6435

ORA-22927: invalid LOB locator specified

1 3399


Un-Answered Questions { Database Errors }

IMP-00064: Definition of LOB was truncated by export

6415


i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2804


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...

2601


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.

2870


ORA-26032: index string.string loading aborted after string keys

2107


how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2213


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

2522


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

8820


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(); } } }

2650


ORA-26084: direct path context already finished

1949


What severity level errors are managed in TRY-CATCH block?

2225


ORA-16626: failed to enable specified object

2218


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

3385


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

2643


IMG-02003: 2FF03 - incorrect color histogram feature specification

1710