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

PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 3243

PLS-00171: duplicate dedicated AGENT specification in subprogram expression

1 2833

PLS-00172: string literal too long

1 8997

PLS-00173: SPACE, TAB or RETURN are disallowed as alternative quote delimiters

1 3915

PLS-00201: identifier 'string' must be declared

1 4286

PLS-00202: type 'string' must be declared

1 3149

PLS-00203: function DECODE must be called with at least 3 non-boolean arguments

1 3409

PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only

1 6116

PLS-00205: Aggregate not allowed here

1 3017

PLS-00206: %%TYPE must be applied to a variable, column, field or attribute, not to "string"

1 5847

PLS-00207: identifier 'string', applied to implicit cursor SQL, is not a legal cursor attribute

2 5268

PLS-00208: identifier 'string' is not a legal cursor attribute

1 6505

PLS-00209: table 'string' is not in FROM clause

1 2957

PLS-00210: an OTHERS clause is required in this CASE statement

1 3277

PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

1 2919


Un-Answered Questions { Database Errors }

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

2787


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

2668


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2300


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


mount: mount to NFS server failed: System Error: Connection timed out

3713


NZE-28890: Entrust Login Failed

1932


What is Mutex error in Triggers?

3130


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

2269


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3229


why we are using shift key in unix shell script

3237


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

2588


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

1769


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

3440


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

2804


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