1 Reply Latest reply: Sep 2, 2010 7:37 PM by mbruegel RSS

    How to call stored procedure with a object (Oracle Type) input parameter?

    792937
      Hi there,

      I am new to OCI/OCCI. I am currently working on a project which need to call a stored procedure with a input parameter to be a Oracle Type object. I don't have ideas on how to implement it, because I used SQLAPI package, which can only bind basic types I think.

      Anyone can give me a hint how to do it?

      I don't use OCI/OCCI now, but SQLAPI instead. SQLAPI can return a Native API. Does anyone know if I can implement it using SQLAPI by it's NativeApi? Or I have to use OCI/OCCI instead?

      Regards
      -Bruce.
        • 1. Re: How to call stored procedure with a object (Oracle Type) input parameter?
          mbruegel
          Some additional info would probably be helpful.

          What is your programming enviironment? Java?

          In any case I suspect that you will need to use the OCI to deal with specific Oracle types such as user defined object types -- thats not standard ANSI SQL.

          In Java I believe you need to use OPAQUE, there are some examples out there. I'm mostly a PL/SQL developer with some Java expereince so others here are more qualifed to answer your question more directly.