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
What is a nvl function?
What do you mean by group by clause?
How to pass parameters to procedures in oracle?
Differentiate between post-database commit and post-form commit?
what are the diffeenes between oracle 9i,oracle 10g
How a tablespace is related to data files?
what is primary key and foreign key when and where have to use
Why do you use stored procedures and state some of its disadvantages?
What is meant by joins?
waht is referencial integrity?
What is save point in oracle database?
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.......