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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do you call an Oracle stored procedure from a VB program.
SirPacs, <br> Its a long time for me since working in VB, but anyway i am not sure about the syntax in VB.<br> There are many ways to execute a stored procedure in VB which is written in Oracle. This can be done using DAO or ADO or RDO.<br> What Jim has told is the easiest way of executing a...- Vinod
- Post #6
- Forum: Oracle: All versions
-
How to get a query to output to a .dbf file???
If u have Visual Foxpro it would be very easy. Just follow these steps.<br> 1. In the Visual Foxpro command window , use the function<br> SQLCONNECT() to connect to Oracle.<br> 2. Use the function SQLEXEC() to run a query.<br> (eg) SQLEXEC(Handle,"Select * from Emp")<br> 3. If u give...- Vinod
- Post #7
- Forum: Oracle: All versions
-
How to get a query to output to a .dbf file???
If u have Visual Foxpro it would be very easy. Just follow these steps.<br> 1. In the Visual Foxpro command window , use the function<br> SQLCONNECT() to connect to Oracle.<br> 2. Use the function SQLEXEC() to run a query.<br> (eg) SQLEXEC(Handle,"Select * from Emp")<br> 3. If u give...- Vinod
- Post #6
- Forum: Oracle: All versions
-
Sizing a database in Oracle
Hai pals, my doubt is that how to size a database in Oracle app for better storage and performance.<br> The database is a very large production system.<br> Can anybody give the approximate Parameter settings,<br> Rollback seg settings, Redo log settings, Datafile settings,<br> Tablespace...- Vinod
- Thread
- Replies: 4
- Forum: Oracle: All versions
