Cast DBMS_SQL.NUMBER_TABLE to another pl/sql table-of-number type?
Using dynamic SQL, I am bulk-collecting two numeric fields into two tables of number. This works fine, the tables are DBMS_SQL.NUMBER_TABLE.
I am trying to feed an API that takes two table of these numbers, but its parameter types are different. Both are identical definitions to DBMS_SQL.NUMBER_TABLE, i.e., TABLE OF NUMBER INDEX BY BINARY_INTEGER.
I don't want to duplicate or copy 2500-7500 records to do this, but I can't find a way to use the api's table-of-number with DBMS_SQL.DEFINE_ARRAY. Nor can I use DBMS_SQL.NUMBER_TABLE with this API. I've tried a few CAST phrases, but it won't compile.
Can someone give me a suggestion here? I'd hate to set up a loop to copy the data from one table to another.
Thanks,
Andrew Wolfe