Home » SQL & PL/SQL » SQL & PL/SQL » how can I read in PL/SQL procedure values of html multiple select
how can I read in PL/SQL procedure values of html multiple select [message #36404] Mon, 26 November 2001 02:14 Go to next message
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 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: how can I read in PL/SQL procedure values of html multiple select [message #36408 is a reply to message #36404] Mon, 26 November 2001 06:16 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use pl/sql table parameter type

----------------------------------------------------------------------
Previous Topic: How do I execute normal SQL from PL/SQL
Next Topic: Disallowing INSERT using Trigger
Goto Forum:
  


Current Time: Thu Mar 28 08:32:33 CDT 2024