call procedure oracle in visual basic 6
 

dear all ,

nice to join this forums. my name nataia, my location now is in Jakarta. i'm working as a programmer.nice to meet you all.

today i have a problem with my application.

i use visual basic 6.0 and oracle for the database.

i have some procedure in oracle. and when i have to call that procedure it can't be.
it just a simple proedure to update table.

i used adodb.connection

my question is:

1. how to call my procedure which are in oracle
2.what should i do for run delete table in oracle. because i can't use sql syntax to delete table in oracle.

plis help me...


thanks to you all ... Bless you :)