"Raja" <[EMAIL PROTECTED]> wrote:
>>I want to pass an array to an oracle stored procedure from ND page. >>The only way
I could think of writing a procedure which can accept array as an input
argument>is
to write a package and have the procedure inside that package.>>But ND does
not see
the packages when I try to create a dataobject using the wizard.>>So how can
I execute
a stored procedure having an array type of input paramater from a ND
page.>>Any
kind of pointers or snippets of code with the PL/SQL procedure and java code
will>be
highly appreciated and woudl really help.>>--------Here the PL/SQL block for
creating
a package/procedure which can accept array type of argument------->>CREATE OR
REPLACE
package array_pack as>type a_array is table of number(9)> index by
binary_integer;>>procedure
test1 (invar in out a_array);>>end array_pack;>/>>CREATE OR REPLACE package
body
array_pack as>procedure test1 (invar in out a_array ) is>counter
binary_integer;>begin>counter
:= 1;>>end test1;>>end array_pack;>/>>-------------End PL/SQL
BLOCK-------------------->>so
how can i use this kind of procedure having an array type input arguemnt
from ND
environment??>I am sure some of you would have come accross this problem and
solved
the same.>>Thanks in advance,>Raja
NetDynamics is yet to support array/vector data types for Oracle procedures.
In our systems,we create a transaction object and add stor proc data objects.
Please let me know if anybody had accomplished this.
Chandu
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
