when we are importing items in inventory, showing errors,
Oracle support suggested us for running scripts & also
suggested if we run scripts, iprocurement applicaation if is
there it will show shared and if we go in future for
iprocurement, it wont work. So kinldy suggest any functional
solution.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

What is a nvl function?

0 Answers  


What do you mean by group by clause?

0 Answers  


How to pass parameters to procedures in oracle?

0 Answers  


Differentiate between post-database commit and post-form commit?

0 Answers  


what are the diffeenes between oracle 9i,oracle 10g

2 Answers  






How a tablespace is related to data files?

0 Answers  


what is primary key and foreign key when and where have to use

5 Answers  


Why do you use stored procedures and state some of its disadvantages?

0 Answers  


What is meant by joins?

0 Answers  


waht is referencial integrity?

2 Answers   Semantic Space,


What is save point in oracle database?

0 Answers  


create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)