Oracle Pipeline tables

2004-02-02 Thread c.w.huling
I have run into an odd issue, using oracle 9.2.0.4, and I am trying a test based on the example in DBD::Oracle, using pipelined tables. I made a small test package: /* @TEST_PKG.SQL SELECT * FROM TABLE (TEST_PKG.F_TEST(6)); var c refcursor exec TEST_PKG.TEST1(6,:c); exec TEST_PKG.TEST2(6,:c);

RE: Oracle Pipeline tables

2004-02-02 Thread Steve Baldwin
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 3 February 2004 2:10 AM > To: [EMAIL PROTECTED] > Subject: Oracle Pipeline tables > > > > I have run into an odd issue, using oracle 9.2.0.4, and I am > trying a test based on the example in DBD::Oracle, u

Re: Oracle Pipeline tables

2004-02-03 Thread Jared Still
Interesting, as I was just doing this today, works fine. See the docs for DBD::Oracle and read the section for bind_inout_param. You can easily return a cursor to perl from PL/SQL. But not the way you're doing it. :) Jared On Mon, 2004-02-02 at 07:09, [EMAIL PROTECTED] wrote: > I have run int