Need Help while running script encountered this error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Need Help while running script encountered this error

Hybrid View

  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Need Help while running script encountered this error

    Hi everybody,

    I am running Oracle 10.2.0.1 database on linux Virtual machine. Running this script as given below, and encountered the problem of

    SQL> conn nzdint/nzdint@NZDefInt
    Connected.
    SQL> @ /home/oracle/Desktop/test.pdc
    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at
    "CTXSYS.CTX_DOC", line 1478
    ORA-06510: PL/SQL: unhandled user-defined
    exception
    ORA-06512: at "CTXSYS.DRVDISP", line 306
    ORA-06510: PL/SQL: unhandled
    user-defined exception
    ORA-06512: at "CTXSYS.CTX_DOC", line 1478
    ORA-06512: at
    "CTXSYS.DRVDISP", line 306
    ORA-06512: at line 9
    User-Defined Exception

    PL/SQL procedure successfully completed.

    SCRIPT test.pdc
    set serveroutput on size 100000
    set pagesize 200
    declare
    -- Local variables here
    vbinaryContent BLOB;
    vTextContent CLOB;
    begin
    -- Test statements here
    dbms_lob.createtemporary(lob_loc => vTextContent,cache => TRUE);
    SELECT content INTO vBinaryContent FROM binary_table;
    ctxsys.ctx_doc.ifilter(data=>vBinaryContent,
    text=>vTextContent);
    INSERT INTO result_table VALUES(vTextContent);
    dbms_lob.freetemporary(vTextContent);
    EXCEPTION
    WHEN OTHERS THEN
    IF dbms_lob.istemporary(vTextContent) = 1 THEN
    dbms_lob.freetemporary(vTextContent);
    END IF;
    dbms_output.put_line(dbms_utility.format_error_stack
    ||dbms_utility.format_error_backtrace
    ||SQLERRM(SQLCODE));
    end;

    IF SOMEBODY CAN WORK OUT WHAT's the PROBLEM AND GUIDE ME TO AVOID THIS PROBLEM, WILL BE a GREAT HELP.

    Thanks

    MACK_DBA

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at "CTXSYS.CTX_DOC", line 1478


    looks like CTXSYS.CTX_DOC has raised a user defined exception which in not being handled by the code.

    Long term solution is to check the code and fix it.
    Exception may be caused by bad data, if that's the case fixing the data would be a nice workaround.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2009
    Posts
    2

    Need Help : while running this script encountered this error

    Hi PAVB,

    Thanks for your response. However, the same script on another server is running without any problems. The another server I am mentioning , has the same configuraton. So, it is bit hard to accept your argument that "code needs to be fixed"

    Can you see any other reason, why the same code runs successfully on one machine and on another it shows this error?

    Look forward for somemore adivce from you.

    Regards,

    Mack_DBA

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Mack_DBA View Post
    Can you see any other reason, why the same code runs successfully on one machine and on another it shows this error?
    Yes.
    Different data, data on one server raises an exception while data in the other server doesn't.
    Either way, code is not able to handle the raised user defined exception.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    The CTXSYS is probably lacking some basic grants.
    Look at dba_dependencies to see what is missing.
    this space intentionally left blank

  6. #6
    Join Date
    Jun 2012
    Posts
    5
    Hello,

    we have the same error. Can you help us ?

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    First you need to provide details one the error, perhaps show some sample code that you are running that shows that actual error stack for your problem. Second, this should be a separate post, as it is not related to whatever happened to the original poster.
    this space intentionally left blank

  8. #8
    Join Date
    Jun 2012
    Posts
    5
    Thank you. I did a new thread already: see "Reload this Page Error with ctx_doc.ifilter under ORACLE 10.2.0.5". There are sample code and error message.

    I hope, it does help you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width