|
| 
| Submitted on: 3/2/2000
By: Aparajit Agarwal
Level: Advanced
User Rating:
By 10 Users
Compatibility:VB 5.0, VB 6.0
Users have accessed this code 9928 times.
| |
| | | It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back
| |
| |
|
Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.
Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
3)Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
Other 1 submission(s) by this author
|
|
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
3/3/2000 6:39:41 AM:Neo
Wow, this is so great and easy to use.
Very flexible too. Nice job there Apu
Dude! Code On and Prosper!
|
3/3/2000 9:20:23 AM:Aparajit Agarwal (Apu)
Hope this works out for folks. Do let
me know if you have trouble making this
work or need help with stored
procedures.
|
4/27/2000 2:24:57 AM:David Downs
How can I create An Oracle SP that
returns data? I'd love to use this
code, but the issue seems to be with
Orcale.
|
4/30/2000 9:33:15 AM:Aparajit Agarwal (Apu)
Unfortunately you can only return
recordsets from Stored Procedures if
you are using Oracle 8.0.5 and higher.
BTW the code should work for other db
also but I have personally not tested.
As far as Oracle goes, for 8.0.5, you
need to have a user type as a formal
in-out based on a
|
4/30/2000 9:36:18 AM:Aparajit Agarwal
(contd)... strong cursor variable which
in turn is based on a complete select
statement in your header specification
of your package. You can then open the
ref cursor in your stored procedure to
return the recordset.
|
4/30/2000 9:37:01 AM:Aparajit Agarwal
(contd)...Unfortunately, this means
that you have to make changes to your
SELECT in 2 places any time you need to
modify it. The good thing about 8.1.5
is that you do not need the strong
variable in your header spec. The
better thing about 8.1.5 is the ability
to use dynamic where clauses as
parameters in your stored procedures.
|
4/30/2000 9:37:37 AM:Aparajit Agarwal
(contd) REF CURSORS in 8.1.5 cannot be
based on dynamically concatenated and
built SQL queries.
I would also
recommend using the ODBC driver 8.0.5
or 8.1.5 whichever the version might be
as opposed to the MSDAORA
provider.
Considering the number of
"queries" :-) I have had in this
regard, I may post a complete example
of this on the site soon.
|
9/3/2000 1:33:47 PM:Natasha Rani
Aparjit Agarwal
Your code has been
immense help. I wander if you could
tell me how I would take the
disconnected recordset from an Oracle
Database and add it to a collection?. I
am not very familiar with collections
but I have heard it is what I need to
do. At the moment I am having trouble
passing recordsets from a datalayer to
a business layer (Oracle 7.0). I would
hence like to put the recordset into a
collection once I have passed it to the
business layer. I can then apss this
information to a web interface. If you
are able to e-mail me back,
natasha_work@hotmail.com. I can send
you an example of what i am trying to
do.
Your help would be very much
appreciated as I am stuck at the
moment!
Thanks again Natasha Rani
|
5/17/2001 11:55:15 AM:Alona
I'm a beginner in VB, and I am trying
to clean up a very simple program that
I wrote. I am going into an Oracle
Database and querying only one table.
I then populate a group of txtBoxes
(not in an array) and can go forward
through the recordset. BUT, I need to
be able to go backward through the
recordset, and I can't get it to
work... Can anyone
help?????
Thanks,
Alona
|
3/7/2002 2:10:24 PM:Dino
Good code. Bottom line it worked, but I
had to spend some time figuring out how
to use it (programming the calling
object) ...( VB beginner). It would be
of great help to post an example of say
a Button_onclick event that makes the
call to your class module.
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
