Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> PL/SQL: table, varray etc. as a procedure parameter?? (newbie)

PL/SQL: table, varray etc. as a procedure parameter?? (newbie)

From: Do not reply <Do_not_reply_at_hotmail.com>
Date: 2000/02/15
Message-ID: <88b7c4$uec$1@nntp.hut.fi>#1/1

Hi,

after going through a couple of thick manuals (Oracle 8 SQL Reference, PL/SQL User's Guide and Reference) I couldn't find a solution.

My procedure "first" creates a dynamical html file with a form. In the form there's n checkbox fields that should be submitted to another procedure
"second" (names changed). How do I define "second" when I don't know how
many parameters it is going to receive?

I tried to name the checkbox fields as f(1), f(2) and so on, and define
"second" to have "m MTABLE" as a parameter. But where should I introduce
MTABLE, which is "table of number index by binary_integer"? As a parameter,
"m is table of..." doesn't work.

Any ideas? I would prefer not to use javascript or anything like that... could "first", when creating the form, create "second" as well, since the number of parameters would be correct. Or is there global variables in PL/SQL I could use?

Thanks in advance.

Jay Received on Tue Feb 15 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US