By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,083 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,083 IT Pros & Developers. It's quick & easy.

Call Oracle procedure from VB6

P: 1

I like to call a procedure of oracle from VB 6.
How can I do it?
help me.
Thank you.

Abhijit Ghosh
Sep 7 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,445

check this :

Expand|Select|Wrap|Line Numbers
  1. Dim MyCmd As New ADODB.Command 
  2. Dim RST As New ADODB.RecordSet
  3. MyCmd.ActiveConnection = AdoCon
  4. MyCmd.CommandText = "{CALL MyStoredprocedure(?)}" 
  5. Set RST = Nothing
  6. Set RST = MyCmd.Execute
Sep 8 '07 #2

Expert 5K+
P: 8,127
Please find the details of calling oracle stored procedure from Vb here.
Sep 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.