Home » SQL & PL/SQL » SQL & PL/SQL » 2 Dimensional Arrays into PL/SQL
2 Dimensional Arrays into PL/SQL [message #224602] Wed, 14 March 2007 13:49 Go to next message
vbbent
Messages: 1
Registered: March 2007
Location: Florida
Junior Member
I am a complete newbie, just started PL/SQL yesterday. I would like to know how to convert a 2 Dimension array say in, C or C++, into PL/SQL. I know that only Vectors are allowed but there must be a way.

For example:

char SetABC [55][4] = {"ABC", "CAB", "EEE", ......, "ZZQ"}

If you need anymore information, please let me know. What is the best way of going about it...a VARRAY? etc?

Thanks in advance.

[Updated on: Wed, 14 March 2007 13:50]

Report message to a moderator

Re: 2 Dimensional Arrays into PL/SQL [message #224643 is a reply to message #224602] Wed, 14 March 2007 21:20 Go to previous message
jdufour
Messages: 4
Registered: March 2007
Junior Member
I suggest you read this.

http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14261/collections.htm#i26701]

[Updated on: Wed, 14 March 2007 21:23]

Report message to a moderator

Previous Topic: ORA-00984: column not allowed here
Next Topic: Tuning this Query
Goto Forum:
  


Current Time: Sat Dec 10 15:02:10 CST 2016

Total time taken to generate the page: 0.14976 seconds