• August 15, 2006 15 Aug'06

    IT managers: Keep software licensing simple

    Software licensing in a world where multi-core processors and virtualization are expected to be the norm is raising a whole new set of challenges for IT managers.  Continue Reading

  • August 14, 2006 14 Aug'06

    ORA-0942 error with embedded views

    I am running into one of those ORA-0942 errors when I create a VIEW with embedded views. The SELECT by itself has no problems, but when I create a VIEW based on this SELECT, the view gets created, but when I do a SELECT on this view, I get ORA-0942.  Continue Reading

  • August 14, 2006 14 Aug'06

    Using BLOB with ctx_doc.filter

    I have a question about ctx_doc.filter. If I have this sentence -- ctx_doc.filter('myindex','1', mklob, TRUE); -- and mklob is the CLOB datatype, this works fine, but if I have mklob as a BLOB, it doesn't. Do you know if Oracle have another ...  Continue Reading

  • August 14, 2006 14 Aug'06

    ORA-04091: table is mutating

    I encountered the error "ORA-04091: table XXXX is mutating, trigger/function may not see it" when I created an after insert trigger. I tried adding PRAGMA AUTONOMOUS_TRANSACTION to the code. The error went away but the table didn't get updated.  Continue Reading

  • August 14, 2006 14 Aug'06

    ORA-02068 with database link

    I have created a database link but I get this error when I try to use the link: "ORA-02068: following a severe error from RTX510 ORA-01034:oracle not available ORA-07429." However the other database is available and running.  Continue Reading

  • August 14, 2006 14 Aug'06

    "Not a valid month" error

    I am trying to perform a partial export of a table. Every day, I want to export just the rows created yesterday. I am using a PL/SQL shell script and executing code in a par file. I get an error: "ORA-01843: not a valid month."  Continue Reading

  • August 14, 2006 14 Aug'06

    Difference between two dates in hours

    How to calculate the difference between two dates in hours?  Continue Reading

  • August 14, 2006 14 Aug'06

    Oracle unveils new version of PeopleSoft CRM

    With the release of PeopleSoft CRM 9, Oracle is following through on its pledge to continue enhancing PeopleSoft products.  Continue Reading

  • August 14, 2006 14 Aug'06

    Trigger to track user password changes in table

    I need to create a trigger which tracks user password changes into a table my_table. I have a database user who has alter user privileges and would like him to change users who belong to his group. That is, when the user changes the password for a ...  Continue Reading

  • August 14, 2006 14 Aug'06

    Bytes of data in LONG datatype column

    I want to see how many bytes of data are stored in a LONG datatype column. I tried using vsize and the length function, but it says I have inconsistent datatypes.  Continue Reading