1 Reply Latest reply on Jan 2, 2020 1:15 PM by Michael Ferrante-Oracle

    Is it possible to read file on client with ORA_FFI package?

    study-feng
    study-feng Dec 31, 2019 10:12 AM

      Hi,

      If I can read the Excel file with "external function", is it possible to read Excel file by calling this function with ORA_FFI package?

      • 82 Views
      • Tags:
        • 1. Re: Is it possible to read file on client with ORA_FFI package?
          Michael Ferrante-Oracle
          Michael Ferrante-Oracle Jan 2, 2020 1:15 PM (in response to study-feng)

          Please clarify your question.  The ORA_FFI package is used for making C calls on the server.  If you wanted to do something similar on the client you could use WebUtil or create your own bean.  Regarding Excel specifically, Oracle recommends using JACOB because it includes both the Java and C libraries needed to make calls from Forms to Excel on the client tier.  If you wanted to use ORA_FFI on the server to call Excel, you would need to refer to the Microsoft documentation to determine what C functions they expose.