default values with out parameter

From: Quantarc <info_at_quantarc.co.uk>
Date: Fri, 09 Jul 2004 15:05:40 +0100
Message-ID: <40eea62a$0$555$ed2619ec@ptn-nntp-reader03.plus.net>

hi, i am accessing an oracle 9.2 database using ado with vb6 (the driver is OraOLEDB.Oracle.1) and i am using reference cursors in package procedures to return recordset back to my application (like described at http://www.vbip.com/books/1861003927/chapter_3927_15.asp). my problem is that i have a procedure whose parameters have default values that i would like to be able to use should i not want to specify parameters as input... which i do like this...

FOO.BAR( ? ); for this procedure...

procedure BAR ( foo number, mycur OUT MYCURSOR );

but i always get an error saying that not all the variables are bound. am i right in thinking that the non-bound variable is the OUT parameter. do i have to specify a default for this? if so what? when i call the procedure with an argument for the 'foo' parameter there isn't a problem, i don't have to specify a variable then.

i have searched the web and usenet but not found anyone else having the same problem.

any pointers would be appriciated, thanx.

rod. Received on Fri Jul 09 2004 - 09:05:40 CDT