Re: VB RDO / Oracle - stored procedures, problem

[Quoted] In article <88s65i$j5u$1_at_nnrp1.deja.com>,   remidesp_at_my-deja.com wrote:
<snip>
> 2)I've also tried using "{begin call dbo.sp_insert_funct (?,?); end;}"
> as query string, as suggested by someone in a few older posts refering
> to a similar problem, with the same results.

This is wrong syntax. Simply use:

"begin call dbo.sp_insert_funct (?,?); end;"

Eliminate the ODBC Escape syntax (the {}) since you are not calling an escape but simply passing in SQL.

Make certain that you have the latest patch version of the driver for your client version -- there was a bug on the Oracle ODBC driver at some point that caused an error like this and it was long since fixed.

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com http://www.deja.com/
Before you buy.