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
_________________________________________________________________________
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]
