Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About kanhasenapati

  • Rank
    Advanced Member
  • Birthday 04/15/1992

Contact Methods

  • AIM

Profile Information

  • Gender
  • Location

Recent Profile Visitors

222 profile views
  1. Hello How can i create fast refreshing Materialized view using complex query and aggregate function . I need this for my Data warehousing project . Please help me asap. Thanks Kanha
  2. kanhasenapati

    FTP from Oracle pl/sql

    Hello, I saw your blog ->http://www.dba-oracle.com/t_invoke_ftp_from_pl_sql.htm but i didn't get where below 2 files are came .which you executed. c:\ftp.pks c:\ftp.pkb can you explain please. thanks
  3. Hii, I need a function to translate a value from English to other language. like select fun_name('infomation','spanish') from dual; function must return infomation word in spanish language.
  4. kanhasenapati

    counting records in pl/sql

    Hi, issue in the counting no of records in complex query. the query contains join , group by and union. when the query executes as a sql statement it works fine, while the same query execute with in the pl/sql block it returns 0(zero).
  5. kanhasenapati

    issue in trigger process

    Hiii, I have a trigger which contains more than 1500 lines of code to process the record. before the process of 1st record complete in trigger, 2nd records comes to process in trigger. so that the second records which is in processing of trigger that record unable to find the unique values ,which are created recently by the 1st record in any other table.
  6. kanhasenapati


    HIII, SELECT DISTINCT A.COL3,B.BLOB_COLUMN FROM TABLE1 A,TABLE2 B WHERE A.COL1=B.COL1; I am getting error ORA-00932: inconsistent datatypes: expected - got BLOB in this query. can any one fix my issue ? How I will use distinct keyword and blob column in a query.
  7. kanhasenapati


    HIIIII I am getting this error ora-00932 inconsistent datatypes expected date got number
  8. Hiii Friends, I am getting this error while I am submitting the bursting control file. --Exception ZIP file must have at least one entry java.util.zip.ZipException: ZIP file must have at least one entry at java.util.zip.ZipOutputStream.finish(ZipOutputStream.java:304) at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine .java:534) at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.jav a:292) at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
  9. kanhasenapati

    Dead lock issue

    Hi burleson, >> deadlock issue data is not inserting into tables. >>>>Can you post the exact deadlock error message? ORA-00060: deadlock detected while waiting for resource can you give me a good solution to fix my deadlock error ?
  10. kanhasenapati

    Dead lock issue

    hiii I have a issue in my database on regular basis. I have 2 dump log table in my database.Both the table contains triggers. continuously data is inserting in the main table. in the main table one trigger is used which check some condition then it insert into a sub table. But some time because of deadlock issue data is not inserting into tables. INITRANS=1,PCTFREE=10 in both tables. By increasing INITRANS, is the the deadlock issue will be fix , if not then give any other solution.
  11. kanhasenapati

    Http error

    Hiii, Thank you for your support. The error comes because of insufficient privilege to principal. my problem is solved.
  12. kanhasenapati

    Http error

    hii , When i call the url from pl/sql block it works fine. but when i call that url from procedure/trigger I got this error ERROR::ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1722 ORA-24247: network access denied by access control list (ACL)
  13. kanhasenapati

    compare performance

    HIII Which one give better performance sub query or join and why ? I know that both of them are used for different purpose but we can use a join statement instead of sub query in some cases in that case which on is better and why? Ex:-1 select empno,ename,sal from emp e ,dept d where e.deptno=d.deptno; Ex:2 select empno,ename,sal from emp where deptno=(select deptno from dept) In the above examples which one is give better performance and why ? Thanks in advance............
  14. kanhasenapati

    increasing (local=no) oracle process

    Hi burleson, thank you .... my problem is solved by changing value of processes in init.ora file.
  15. kanhasenapati

    close connection based on idle time

    Hi burleson, >>I have lots of notes on this: >>http://dba-oracle.com/googlesearchsite_pro...334j11473546j17 I already read that but till now my problem is not solved. My problem is after the idle_time exceeds neither my user status is snipped mode . I want to disconnect and kill the processes of that user after idle_time exceeds.