3 Replies Latest reply: Jan 9, 2013 6:10 AM by Billy~Verreynne RSS

    How to solve error ORA-22621

    849208
      Hello friends,

      While returning array from external function i am getting error as below:

      Oracle Error: ORA-22621

      Error Description: Error transfering an object from the agent

      Error Cause: Any error returned from pickler routines on the agent side.

      Action: Contact Oracle Support.

      last 3-4 days i am searching for this error but i am not getting any solution.
      Please help me.
      Thanx in adavance

      Regards,
      Nilesh
        • 1. Re: How to solve error ORA-22621
          Manik
          Similar prob solved:

          http://metekarar.blogspot.sg/2012/11/oracle-enterprise-r-output-error-ora.html

          Cheers,
          Manik.
          • 2. Re: How to solve error ORA-22621
            849208
            Thanx for your valuable reply

            http://metekarar.blogspot.sg/2012/11/oracle-enterprise-r-output-error-ora.html

            but above link does not solve my problem.

            Edited by: Nilesh Jethawa on Jan 9, 2013 3:36 AM
            • 3. Re: How to solve error ORA-22621
              Billy~Verreynne
              Nilesh Jethawa wrote:

              While returning array from external function i am getting error as below:
              External procedures are not PL/SQL procedures or SQL code - so not really part of the subject matter of a forum about the SQL and PL/SQL languages.
              Oracle Error: ORA-22621
              Error Description: Error transfering an object from the agent
              Error Cause: Any error returned from pickler routines on the agent side.
              Action: Contact Oracle Support.
              Well, you can try and see if there are forum members that have perhaps an inkling of what went wrong and how to go about resolving it.

              But to do that, more details are needed. Such as:
              - Oracle version
              - o/s version
              - type of external procedure (PL/SQL lib definition code, language ext proc is written in, how it is compiled, etc)
              - ext proc definition (as per the local listener)
              - copy and paste of a SQL*Plus session calling the ext proc (with full error stack included)

              Alternatively, log a service request with Oracle Support?