01-15-2008
How to declare an array to take more than 10,000 characters
Hi Guys
Need some help
I am reading the string values from the text files into the shell script and had them feed into array
I have declared an associative array as
TYPE t_user_id_tab IS TABLE OF VARCHAR2(3000);\n
my_user_id t_user_id_tab;\n
varchar2 is limiting me to take only 32760 characters
but I have a text files which has more than 1100 users with length of each user id is 8
1100* 8 = 8800 + the '',sapces
so I am looking around 10,000 characters is there a way that I can declare the array of string to take 10,00 characters
Thanks in advance
Pinky
5 More Discussions You Might Find Interesting
1. News, Links, Events and Announcements
Surreal quote from the news link below:
http://www.washingtonpost.com/wp-dyn/articles/A44615-2002Nov12.html (0 Replies)
Discussion started by: Neo
0 Replies
2. Shell Programming and Scripting
using bash Tru64...
converting DCL to shell...
any tips to make this work would be greatly appreciated.
Below is my failed attempt to assign command line input to variables by first declaring an array. I use a counter to create unique variables in a loop through the array. I need to call... (3 Replies)
Discussion started by: egkumpe
3 Replies
3. Shell Programming and Scripting
Hi,
I wish to store $string1 in $string1array a character in each array element.
Then i wish to echo the entire array to the screen so that it reads as the normal string again.
I have been trying with the code below but does not work. Please help...
To put string into array:
... (5 Replies)
Discussion started by: rorey_breaker
5 Replies
4. UNIX for Dummies Questions & Answers
Hello,
In a shell script, I want to declare an array and subsequently print the elements with tab delimits.
My array has the following structure and arbitrary elements:
myArray=('fgh' 'ijk' 'xyz' 'abc');
Next, I would like to print it with a '\n' at the end.
Thanks for your input!
... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies
5. Programming
I am attempting to create an array of function pointers. The examples I follow to do this are from:
support.microsoft.com/en-us/help/30580/how-to-declare-an-array-of-pointers-to-functions-in-visual-c
... (3 Replies)
Discussion started by: spflanze
3 Replies
LEARN ABOUT PHP
ingres_fetch_assoc
INGRES_FETCH_ASSOC(3) 1 INGRES_FETCH_ASSOC(3)
ingres_fetch_assoc - Fetch a row of result into an associative array
SYNOPSIS
array ingres_fetch_assoc (resource $result)
DESCRIPTION
This function is stores the data fetched from a query executed using ingres_query(3) in an associative array, using the field names as
keys.
With regard to speed, the function is identical to ingres_fetch_object(3), and almost as quick as ingres_fetch_row(3) (the difference is
insignificant).
By default, arrays created by ingres_fetch_assoc(3) start from position 1 and not 0 as with other DBMS extensions. The starting position
can be adjusted to 0 using the configuration parameter ingres.array_index_start.
Note
Related Configurations
See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $result
- The query result identifier
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows
EXAMPLES
Example #1
Fetch a row into an associative array
<?php
$link = ingres_connect($database, $user, $password);
$result = ingres_query($link,"select * from table");
while ($row = ingres_fetch_assoc($result)) {
echo $row["user_id"]; // using associative array
echo $row["fullname"];
}
?>
SEE ALSO
ingres_query(3), ingres_num_fields(3), ingres_field_name(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).
PHP Documentation Group INGRES_FETCH_ASSOC(3)