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

VB to ORacle 9i problem in stored procedure

P: 23
Hi

VB to ORacle 9i
Can any one help me to get record count in vb from a oracle stored procedure.I dont want put in loop to get the record count in oracle store procedure and return.In SQL when we used to call a function which excutes a query it used to return a record set using that we used to get record count but this does not happen in Oracle
May 4 '07 #1
Share this Question
Share on Google+
1 Reply


P: 3
hi
The solution is simple:
dim rc as ADODB.recordset
dim cn as ADODB.Connection

' Make connect as you want

rc.open "select count(*) as Fld1 from tablename where <condition you want>",cn

Msgbox "Number of Records: " & rc!Fld1

[email removed]
May 7 '07 #2

Post your reply

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