Alexander Smirnov wrote:
> 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
One is SQL the other PL/SQL. The rules are different with regard to
array types and permissions. Get out of OLE and run these from the
SQL*Plus command prompt so you can see what is actually going wrong.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 05 2007 - 08:23:08 CDT
