OraFAQ Forum: Forms » How to do Array

Home » Developer & Programmer » Forms » How to do Array

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

How to do Array [message #178398]

Wed, 21 June 2006 01:18

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Good day.
Anybody here could help me how to
store in the elements of a variable
just like how in turbo C array or VB array?
e.g.:
my_array(1) = 'a';
my_array(2) = 'b';
my_array(3) = 'c';

It's too messy to declare
50 variables than to do this one.

thx.

Report message to a moderator

Re: How to do Array [message #178427 is a reply to message #178398]

Wed, 21 June 2006 02:32

aciolac
Messages: 242
Registered: February 2006

Senior Member

Use RECORD in PL/SQL:
DECLARE
rec IS RECORD(
var1 ...
var2 ...
);
BEGIN
....
END;

Report message to a moderator

Re: How to do Array [message #178441 is a reply to message #178398]

Wed, 21 June 2006 02:58

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Is it supported in Oracle 2.1?
I can't find the correct syntax and/or example in
oracle help.

Do you have a simple running code?

Report message to a moderator

Re: How to do Array [message #178819 is a reply to message #178441]

Thu, 22 June 2006 23:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Oracle 2.1 - do you mean database, forms, or PL/SQL?

David

Report message to a moderator

Re: How to do Array [message #179118 is a reply to message #178398]

Sun, 25 June 2006 19:01

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Hi David,

It's on forms. tnx

Report message to a moderator

Re: How to do Array [message #179142 is a reply to message #179118]

Mon, 26 June 2006 00:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Oracle Forms 2.1 is seriously old, like 1985-88. I don't think that the version of PL/SQL at that time supported arrays.

David

Report message to a moderator

Previous Topic:	Set the visual attribute for several records in a block
Next Topic:	How to change USER at runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 02 17:38:16 CDT 2026