Stored Procedure to process a Excel Spreadsheet
Posted by:
Jerry Ball
Date: October 31, 2016 05:24AM
Can I create a stored procedure that when it is called, it will perform the following:
1. Get an excel spreadsheet on the system. and open it.
2. Read a row. in column B, perform a validation of field to a table, if
not found, put an asterisk in column b1,
3. perform the same steps of #2 in column D. When done the update the row
and get the next row until eof.
4. When done, close the spreadsheet and exit.
5. If I create this stored procedure, can I then export it and use to go
against another db on a different machine.
6. My objective is to develop the stored procedure and then use it to be
called and executed against the clients db.
Can someone, plz give me some direction on doing this. Than in advance.
Jerry
Subject
Views
Written By
Posted
Stored Procedure to process a Excel Spreadsheet
5225
October 31, 2016 05:24AM
895
November 01, 2016 09:29AM
907
November 01, 2016 02:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.