Tuesday, May 8, 2012

Oracle SOA - BPEL- An error occurred while preparing and executing the Temp_QUERY_CUSTOMER_PKG.Temp_QUERY_INVOICE_HEADER_PRC1 API. Cause: java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype


If you re-create an Oracle Database PL/SQL statement or other schema object (such as a data type), or recompile a package body, and re-deploy a SOA composite that uses the Oracle Database Adapter, then the Oracle Database Adapter runtime will throw an ORA-00902: invalid datatype exception.
The workaround for this issue is to set the following Oracle WebLogic Server properties:
  • Data Source:
    • Initial Capacity: 0
    • Statement Cache Size: 0
  • Adapter Connection Pool:
    • Initial Capacity: 0
If your SOA composite is incompatible with these property settings, the workaround for this issue is to stop and start the Oracle WebLogic Server.
Posted by at

4 comments:

  1. BabsOctober 17, 2012 at 10:23 PM

    Thanks mate, I was struggling to debug what was my issue, I bounced the Oracle WLS and it started to work, really thanks to you!

    ReplyDelete
  2. UnknownAugust 13, 2013 at 8:27 PM

    Same with me Bouncing the Server really help. Thanks A lot man!

    ReplyDelete
  3. Ashley RosaSeptember 22, 2019 at 9:20 PM

    The unexpected issues associated with verification of Bithumb transaction has been known as the most common one among all its users. The process related to it is very significant to transaction concerns. Thus to get issues fixed within very short time, it is mandatory to contact the support team, calling on Bithumb support number.This number has been provided online with a view to creating convenience to our viewers for easy access to the experienced executives.

    ReplyDelete
  4. StevenHWickerMarch 2, 2022 at 9:31 PM

    Thanks for this. I really like what you've posted here and wish you the best of luck with this blog and thanks for sharing.Qué es BPM

    ReplyDelete

Subscribe to: Post Comments (Atom)