passing an entire table to a stored procedure for update
Database
1
Posts
1
Posters
0
Views
1
Watching
-
hi i have had that problem for some time now, where i wish to receive data from another source, format it into a datatable sturcture identical to a data table in my database, and pass said data table to an Oracle database in order to update said data table. consulting with one of my DBA's i've been refered to the SYS_REFCURSOR object, however i could not find any explenation on it anywhere. i would very much appriciate someone telling me first if i'm only daydreaming and what i want is impossible, and if it is possible, some way of coding it.