PL/SQL package could manipulate Microsoft Word/Excel?

No problem. If you need help with VBA interacting with the Oracle Database, I can help as I've done it before.

Once you've installed the Oracle OLE DB driver on the machine the Excel file resides, you need to reference it from the "Tools -> References" menu of the VBA editor menu:

In the path I can see the directory where I installed the OLE DB driver. You also need to tick the ADO Library driver if it's not the case:

Once this is done, the way to interact with the DB is pretty simple.

First, you need to connect to the DB:

Dim Conn As ADODB.Connection
Dim vHost As String
Dim vPort As Integer
Dim vService As String
Dim vUser As String
Dim vPwd As String
On Error GoTo ErreurConn
With Conn
   .ConnectionString = "PROVIDER=OraOLEDB.Oracle;USER ID=" & vUser & ";PASSWORD=" & vPwd & ";DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST = " & vHost & ")(PORT = " & vPort & ")))(CONNECT_DATA =(SERVICE_NAME = " & vService & ")))"
   .Open
End With

The variables needed to connect can be set in the code, or they can be inputs from the worksheet. For example:

vHost = Range("B1").value
vPort = Range(« B2 »).value
vService = Range(« B3 »).value
vUser = Range(« B5 »).value
vPwd = Range(« B6 »).value

If you want to test that the connection is ok, you can do:

If Conn.State = 1 Then
  MsgBox "Connection Successful"
   Conn.Close
   Set Conn = Nothing
End If

Now any command you want to pass can use this connection. For example, if you want to perform a SELECT statement with bind variables, you do as follows:

'variables
Dim vQuery As String
Dim SQLCommand As ADODB.Command
Dim Param As ADODB.Parameter
Dim Rs As ADODB.Recordset

vQuery = "SELECT * FROM T WHERE id = :id"

 
Set SQLCommand = New ADODB.Command
With CommandSQL
  .ActiveConnection = Conn
  .CommandText = vQuery
  .CommandType = adCmdText 

  'value for the bind variable
  Set param = .CreateParameter("id", adNumeric, adParamInput)
  param.value = 1
 .Parameters.Append param 

  Set Rs = .Execute
End With

'Browse the recordset
Do While Not Rs.EOF

    'Retrieve the column values

    vVal = Rs.Fields("val")
    vCreationDate = Rs.Fields("creation_date") 

    Rs.MoveNext
Loop

Set Rs = Nothing

If you have more than 1 bind variable, then add another .CreateParameter construct and append it to the Parameters collection.

The logic is similar for other kind of commands (DML statements, calling stored procedures and functions). I can provide you with examples if necessary.