Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: calling stored procedure with an array parameter using Oracle Object for OLE (OO4O)
Alexander Smirnov wrote:
> It's not a passing in an array as a parameter. It's passing in an
> array of parameters for wich oracle executes procedure many times
> though I call ExecSql only one time (that's how I understand it
> works).
> Yes it's much faster. As I wrote If I specify SQL statement in
> ExecSQL (for example INSERT) than I don't get the PLS-00306 error.
Subject: "calling stored procedure with an array parameter" Response: "It's not a passing in an array as a parameter"
What?
And if it doesn't work how did you determine it is faster?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Jul 04 2007 - 16:57:15 CDT