couple of things.
- You VBS custom/event scripts should have vbs extension
- If you are willing to use VB for your scripts, take a look to sample scripts in the admin guide to see how you define the header in the script in order to get the correct parameters and be able to initialize the API.
- If you are planning to have the oracle db as a source for your data integration you may look to another approach than using a custom script.
You would have to use Open Interface Adapter. You can write event script BefImport in order to move data from your oracle db to open interface table.
you have a sample script to load data into open interface table in the admin guide.
I hope that clarifies.