not all variables bound

From: Quantarc <info_at_quantarc.co.uk>
Date: Tue, 13 Jul 2004 11:52:50 +0100
Message-ID: <40f3bf02$0$92613$ed2619ec@ptn-nntp-reader02.plus.net>

i posted a message a few days ago with a problem with an out parameter in a package procedure i was using to return a recordset via ado to my application. i am now trying using a function instead, and this works when i pass in all the variables again, but if i leave any out if STILL tells me that not all the variables are bound (i kinda understood before when the final out parameter hadn't been bound, but with this all the variables really seem to me to be bound).

here's the test package i'm trying this with...

--

• package TEST
  --
  

create or replace package TEST as

	type MYCUR is ref cursor;
	function FOO( mynum NUMBER DEFAULT -1 ) return MYCUR;

end TEST;
/

create or replace package body TEST as

function FOO ( mynum NUMBER DEFAULT -1 ) return MYCUR
is

        myc MYCUR;
begin

	open myc for
	select * from my_table;
	return myc;

end FOO;

end TEST;
/

--

• end package TEST
  --
  

i am calling the function from my application via ado like so...

{call TEST.FOO( ? )}

but this doesn't work. i just get the error "not all variables bound".   this does however...

{call TEST.FOO( 1 )}

am i not using default variables properly? or can anyone see another problem? i have been beating my head against a wall with this problem for about 3 weeks now and i really need to solve it soon. any help or pointers would be appriciated.

i am using oracle 9.2, the OraOLEDB.Oracle.1 driver from VB6.

thanx.
rod. Received on Tue Jul 13 2004 - 05:52:50 CDT