| how can I read in PL/SQL procedure values of html multiple select [message #36404] |
Mon, 26 November 2001 02:14  |
D.
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
how can I read in PL/SQL procedure values of html multiple select:
for example:
//server/package.procedure?multiple_select=1&multiple_select=2
but when I use parameter multiple_select in procedure's body its value is 1 (not 1,2 as in
Active Server Pages)
therefore I can't use query
SELECT * FROM table WHERE column IN multiple_select
----------------------------------------------------------------------
|
|
|
|
| Re: how can I read in PL/SQL procedure values of html multiple select [message #36406 is a reply to message #36404] |
Mon, 26 November 2001 05:18  |
hello
Messages: 17
Registered: November 2001
|
Junior Member |
|
|
When u define the procedure
ucan have it like
Procedure test (multiple_select1 in number,
multiple_select2 in number default null)
as
begin
select * from table where column in (multiple_select1,multiple_select2)
In this way u will fetch both the values. It is not possible in PL/SQL to get as 1,2 in a single variable
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
