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?
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.