send a table of records from pro C to Oracle pl/sql stored procedure

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Eranut

    send a table of records from pro C to Oracle pl/sql stored procedure

    Hi,

    I am trying to understand if there is a way to send a table of records
    (table of structs) from pro C to Oracle pl/sql stored procedure.
    Since Oracle is demanding definition of the *sent* array exactly as it
    is define in the *recieving* end I am not sure it is possible.

    Thanks
    Eran
  • Mark D Powell

    #2
    Re: send a table of records from pro C to Oracle pl/sql stored procedure

    eranut@gmail.co m (Eranut) wrote in message news:<c8a04c6a. 0408251648.783e 2dc@posting.goo gle.com>...
    Hi,
    >
    I am trying to understand if there is a way to send a table of records
    (table of structs) from pro C to Oracle pl/sql stored procedure.
    Since Oracle is demanding definition of the *sent* array exactly as it
    is define in the *recieving* end I am not sure it is possible.
    >
    Thanks
    Eran
    Look up array inserts and bulk load in the manuals. You can also call
    a stored procedure or submit anonymous code from a Pro*c program.

    Which, depends on exactly what you want to do.

    You may get more responses if you posted in the
    comp.databases. oracle.tools group.

    HTH -- Mark D Powell --

    Comment

    Working...