Take a look here for oracle connection strings:
http://www.connectionstrings.com/?carrier=oracle
Triggers are really a database specific question. Try an oracle database forum.
To call a stored procedure, create an instance of a Command class (OleDbCommand, OdbcCommand) and set the command text to the name of the sproc. Then you can add parameters to the .Parameters collection.
-
Peter