-
Hi all
Can we pass an array definition in the parameters list of a function or procedures. For e.g.
Create or replace function tem_1 ()
begin
for i in .. loop
end loop;
This is required for Java programmers who are calling different procedures where the no. of parameters are fixed from Java programs, but now they want that the list of parameters should not be fixed and they should be able to pass as many parameters with datatypes. I havent found any such facility in oracle. Can you all help me out in this
Thanks in Advance
Amol
-
yes we can, go to asktom.oracle.com and serach for array procedure
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|