Search code examples
oracleplsqloracle11godp.net

Is it possible to pass types defined in plsql package headers using odp.net?

  TYPE point IS RECORD (
  X NUMBER,  -- The X co-ordinate of the point
  Y NUMBER   -- The Y co-ordingate of the point
  );

This is defined in my package header. It is then used in a procedure defined in the same package. Is it possible for me to call the procedure via ODP.net?

Solution

  • I don't know if you can pass a record, but the article about Using PL/SQL Associative Arrays might help.

    The author uses two arrays to pass min_salary and max_salary, you should be able to do the same with x and y.