Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Executing a procedure

Status
Not open for further replies.
vijiprahad

vijiprahad

Programmer
May 1, 2001
2
US
Hi all,

I am connected to the oracle database through a ODBC. I need to execute a procedure in my database from my VB code. How should i do it?

Thanks for any help,
Viji
 
Sort by date Sort by votes
If it is a simple procedure that returns no resultset and has no parameter then you could just use the .Execute method of your ADO Connection object.

If it is a more complicated procedrue then it is better to use the ADO Command object.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
send email with a free sever smpt api rest
Replies
3
Views
462
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Rotate every 6th page in a PDF 1
Replies
7
Views
709
Rick998
Rick998
Ken01
  • Locked
  • Question
Display Imageboxes on a PictureBox 1
Replies
1
Views
360
strongm
strongm
Ken01
  • Locked
  • Question
I have a program, developed in VB6
Replies
6
Views
888
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top