Insertion of an array of data into Oracle table with stored proc

From: cvissy (c.k.b_at_webmail.co.za)
Date: 05/14/04

  • Next message: Josef Garvi: "Re: Reporting Tools" 
    Date: 13 May 2004 23:58:21 -0700

    Hi,

    Im new to Oracle and need to insert an array of lines of data (data is
    String and int values), with each item in the array representing a
    record for insertion e.g.

    line 1 [intVal1, strVal1, strVal2]
    line 2 [intVal1, strVal1, strVal2]
    line 3 [intVal1, strVal1, strVal2]
    line 4 [intVal1, strVal1, strVal2]
    line 5 [intVal1, strVal1, strVal2]
    line 6 ..
    line 7 ..

    I am looking at an array of structures - has anyone done this before?
    How did you do it?

    Thanks
    Chris

  • Next message: Josef Garvi: "Re: Reporting Tools"

    Relevant Pages

    • (patch for Bash) regex conditional tests
      ... 'regex' are returned in array variable SUBMATCH. ... Skipping of positional parameters, array elements, string ... int dollarflag, zeropad, compareflag; ... SHELL_VAR *var; ...
      (comp.unix.shell)
    • Re: String of numbers into to array of numbers
      ... then read that string and have the string show the ... individual numbers as in an array. ... int arryCnt = 0; ... qStr= cStr.substring); ...
      (comp.lang.java.help)
    • Re: How to Return an array of strings in C (char**)
      ... int start=0; ... // to know the number of elements in the array ... The reason is that you fail to increment str. ... The you could have printed "here" before entering the main loop to see if you actually got there, then str + start to see where you go to in the string on each pass. ...
      (comp.lang.c)
    • Re: read keyboard input and storing in an array?
      ... When in a loop, how do I simply ... The data returned by 'br.readLine' would always be a String so I've stored ... simply convert it to an int as follows: ... you could copy 'myInt' to your array. ...
      (comp.lang.java.help)
    • Re: passing a string to a dll
      ... Joe, I really appreciate you taking the time to demonstrate this. ... sure how I would implement indexing it for random alphanumeric codes. ... I might handle the array. ... I actually have been wondering if I could use a second string ...
      (microsoft.public.vc.mfc)