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
);
开发者_C百科
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?
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
.
精彩评论