OraFAQ Forum: Forms » Assign multiple values to variables

Home » Developer & Programmer » Forms » Assign multiple values to variables (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Assign multiple values to variables [message #549506]

Sat, 31 March 2012 07:43

vinni
Messages: 34
Registered: March 2012

Member

hello
having a little trouble with assigning values to a particular variable that i need for my button trigger. I Understand that you can assign multiple values to a variable that has a varchar or char data type....
is there a way to assign multiple values to a variable that has a 'number' data type?? I need this for my 'where' clause

declare
	usergrade varchar(4) := 'pass';
	user_unitcode number(6) := ;--needs three unit codes to equal pass

Report message to a moderator

Re: Assign multiple values to variables [message #549507 is a reply to message #549506]

Sat, 31 March 2012 08:19

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Varying elements in IN list on AskTom might be what you are looking for.

If you read the whole discussion, you'll probably find a global temporary table (GTT) solution of the problem, i.e. you'd insert these values into a GTT and use it in your WHERE clause as

-- insert some records into a GTT
insert into gtt (id) values (1);
-- or possibly
insert into gtt (id) values (:form_block.some_item);
...

-- now use them in WHERE clause:
select ...
from some_table
where id in (select id from gtt)
  and ...

Report message to a moderator

Previous Topic:	Java timeout connection Error
Next Topic:	Connect using proxy user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 23:52:25 CDT 2024