On Jul 5, 1:57 am, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
OraDatabase.ExeceSQL("insert into T(p) values(:p)");// works using
array parameter
OraDatabase.ExecSQL("begin insert_proc(:p); end;"); // doesn't work
using array parameter
Received on Thu Jul 05 2007 - 05:56:57 CDT
