Using an Oracle Stored Procedure on a column in an Excel
Hi, I have a question regarding using an oracle stored procedure on a column from an excel spreadsheet.
Let's say I already have two connections established, one for the oracle database and one for the excel folder.
For a simplified example, I have a stored procedure in oracle database that is called 'CODETONUMBER' which will read a letter and output a number (A to 1, B to 2, C to 3, etc). Then I have a table called 'LETTER' which is from the excel and the table has a column called 'LETTERCODE' which contains a letter from A to Z.
In the Data Load Editor, I have connected to the oracle database using the lib connect. Then I did the following:
LOAD
<database_name>.<user>.CODETONUMBER("LETTERCODE")
FROM [lib://Letter/Letter.xlsx]
and this failed, I think it is because the excel does not have this procedure.
Is there any way to call for a stored procedure from the database onto a column in the excel file?
