Re: ODCITableDescribe not picking up parameters

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 30 Jun 2012 16:16:42 +0200
Message-ID: <4fef0a47$0$6451$426a74cc_at_news.free.fr>

<matthew.f.macari_at_gmail.com> a écrit dans le message de news: 10232227.2576.1333490469304.JavaMail.geo-discussion-forums_at_yncd8...
| I'm attempting to implement the ODCITable interface to build a interfaced pipeline function. When I go to call my code from a
query, the parameters I am passing the pipelined function are all being passed into the ODCITable* functions as null values.
|
| Essentially, what I am trying to do is be able to do this:
| select *
| from table(some_package.show(id1 = 12, id2 = 1234));
| and have it return the resultset back as an abstract table. I have the code to make parse the query and build it, but my
parameters are being pass as nulls.
|
| ...

SQL> select * from table(type_test.show(12,1234)); type_test_success_12

---

1 12
2 12
3 12
4 12
5 12
6 12
7 12
8 12
9 12
...
1229 12
1230 12
1231 12
1232 12
1233 12
1234 12

1234 rows selected.

Your code works for me.

Regards
Michel Received on Sat Jun 30 2012 - 09:16:42 CDT