This discussion is archived
1 Reply Latest reply: Sep 2, 2010 5:37 PM by mbruegel RSS

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

792937 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points