Sql - Retrieve Oracle DBMS_Output From A Application
Aug 4, 2010
I'm working on a vb.net application that executes an Oracle stored procedure. The stored procedure displays a value using dbms_output.put_line. How do I retrieve that value from the oracle database into my vb.net code?
View 1 Replies
ADVERTISEMENT
Apr 18, 2012
I`m using oleDbConnection in order to Select a BLOB data from Oracle column, and I have to stick with this type of connection since all my application is using it.
After I used the following code, I got the error: unspecified [code]....
View 1 Replies
Apr 13, 2011
I have some stored procedures to execute that use dbms_output.put_line() to put data into the output buffer.I know I need to use dbms_output.get_line(:line, :status) to retrieve that output.I'm using ystem.Data.OracleClient to avoid headaches with Oracle deployment.So what am I doing wrong with the code below?
Dim cmdSproc As OracleCommand = cnOracle.CreateCommand()
Dim strOracle As New OracleString()
Dim opaLine As New OracleParameter("lineOut", OracleType.VarChar, 255)
[code]....
View 1 Replies
Jul 5, 2011
want to know how to connect database from window2008 server platform to ibm aix database is oracle 10g ..please anyone can help me here
View 2 Replies
Dec 27, 2010
I have a problem related, not only to VB.net, but also Oracle.I have a simple application that runs queries from an Oracle db (Oracle 9i) and creates reports from it. I am using the official oracle.dataAccess component.I need a very simple report that returns a list of usernames. Something like "SELECT userName FROM users".(userName field is a VARCHAR2).Problem with this query:The top 50 rows are OK.All the remaining are strange characters.
[Code]...
View 4 Replies
Jul 27, 2009
I want to create Table in Oracle database from my asp.net application by using ado.net
View 1 Replies
Nov 21, 2009
I'm starting using a project for smart device in windows CE 5. I'm using visual basic of v. studio 2008.I need to create a dynamic connection between a PDA (codebar lector) and an server with ORACLE 9i. The PDA connected via WIFI. But in my vb project I don't find OLEDB or ODBC elements.
View 2 Replies
Dec 2, 2009
I have a vb.net application that will not connect to an oracle database on the PC that I publish the app too. It works fine under my pc both in design and when I publish it to myself. But it will not connect under the pc I publish it too. I do have oracle installed on the pc and have the connection setup exactly as I have on my own pc. I am sure it is a file path issue, or at least I believe it to be that.
View 5 Replies
Nov 22, 2011
i have an application with access .accdb as backend.How can i convert the backend to OracleBL (Visual Studio 2010 Ultimate)
View 3 Replies
Mar 4, 2010
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Replies
Dec 29, 2009
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 Replies
May 26, 2011
I am in need of a small application, that will allways be topmost and will send keystrokes to the last active application (typically notepad or an explorer window). My problem is retrieving the current active form (or application), when my application is started up. Every search seems to return old and rather complex solutions using Win32 library functions, but I was kinda hoping, that .Net allowed for a neater and more simple solution.I need a code example or link on how to retrieve the currently active application window from another application just starting up.
View 2 Replies
Oct 2, 2009
Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
View 3 Replies
May 14, 2009
I want to (SQL) select from a table in an Oracle database, and show the results of the query in the VB application, in a Excel like manner (rows, columns, selectable, etc.). Or in a SQL developer manner. How can I do that? Browsed through a lot of tutorials and howtos on the internet, did not get anywhere. I think (and correct me if I am wrong) that it's gotta be something with DataGridView. But I don't know how to create and populate a datatable with the result of as Select statement, how to create a dataset.
View 3 Replies
Jan 17, 2009
Im building a payment system in VB (2008) using Windows Forms (Applications). Im trying to find out how it is possible to get the IP address of my machine and display it to a text label. I did a bit of surfing and cant find a solution, i tried this code below, but doesnt like the word "Request", so i tried adding all the imports web, data, net, etc, but cant get it to work.
Dim StoreIP As String
StoreIP = Request.UserHostAddress
Me.TextBoxIP.Text = StoreIP
View 1 Replies
Mar 18, 2008
Is there any way I can make a vb.net application that will allow me to retrieve the gmail inbox into my Application? I can use gmail Smtp server to send the mails, the problem I am facing is that I cant receive the mails from gmail to my application?
View 39 Replies
Feb 14, 2012
Retrieving the COM class factory for component with CLSID {40942A6C-1520-4132-BDF8-DC1F71F547B} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).How can I retrieve MODI reference from COM in my application ? I have no dll file of MODI.& I have used the reference file called AxInterop.MODI & Interop.MODIBut I am not able to execute the application.I need this file to retrieve text from images.
public partial class Form1 : Form
{
public Form1e & Btnclick as Button
[code].....
View 2 Replies
Dec 1, 2011
In VB.Net, I can retrieve my application's ProductName and CompanyName by using:
My.Application.Info.ProductName
My.Application.Info.CompanyName
How do I do the same thing in C#?
View 3 Replies
Jun 16, 2011
I need to retrieve the actual text of a message box from another application. When using WM_GETTEXT, the values returned are the title of the message box, and the text of the control button (in this case "OK").
My issue is that what I really need is the actual text message from the box itself. I've been researching this for days and can't find a way to do this. Nothing I have found so far tells me how to do this.
View 11 Replies
Nov 25, 2009
I have one project and in this project I want to save picture to application path and save the path to database as string and retrieve the image from the application path.Can u give me some idea about it..i am using vb.net as frontend and ms access database
View 1 Replies
Jun 3, 2011
i have an application that store a data about a properties for sall i use the serlization and desrlization to store the property details to an XML file i call it PropertiesList .xml..i got a form called search it contain 2 text boxes when the user write down a postcode for a property then click search i need the application to search the xml file that contain the details and retrive all the properties that match the searching words and list the result in a list box.
View 1 Replies
Aug 29, 2010
i need to design an application in visual basic 2005 that will retrieve pictures on a form. PS: All pictures should be located in a combo box! And the number of pictures are 2000.I've started with cmb.Items.Add("pic1") but that really tiresome to write 2000 codes.
View 9 Replies
Apr 15, 2009
i am getting "Unable to retrieive application files. File corrupt in deployment" on clickonece technology
Log:-
SOURCES
Deployment url : http://192.168.1.1/Employee/emp.application
Server : Microsoft-IIS/6.0
X-Powered-By : ASP.NET
[Code]...
View 1 Replies
Jun 17, 2009
I'm using VB.NET in Visual Studio 2008 in a Vista 64-bit OS. I'm trying to find an easy way (there must be one) to quickly retrieve from the registry the application file name and path to use in a Shell command to open a particular file. Specifically, I want the user in my app to be able to click on a PDF file and have the app open that PDF file using the application associated with PDF file types - Acrobat Reader, for example. Anyone have any suggestions as to proper coding & syntax for the following sequence?:
(1) Get name of .exe file associated with .pdf file type (most likely from the HKey Root Classes hive)
(2) Get path for the .exe file
(3) Shell("[pathname]appname.exe filename.pdf")
I've spent a couple of hours looking through the forums and haven't found what I'm looking for.
View 3 Replies
Jul 2, 2010
i Use "Imports System.Data.OracleClient .. Private conn As New OracleConnection()" to connect to my Oracle database..but when i put my program to another PC I need install Oracle Client on it...is there some other way how to connect to Oracle DB without installing oracle client to client PC?? (Database is on Server an program is on client´s PCs)
View 2 Replies
Apr 8, 2010
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
View 2 Replies
Jun 18, 2010
I have some code I am trying to get to work. I open a url and then I want to get that same url address from the opened we page web. For some reason when I place parameters in the object.navigate statement the locationURL comes back empty
[Code]...
View 2 Replies
Feb 5, 2010
I am a biologist and I have a collection of dive data. It is very simple data...just time and depth (m). However, from each data set, I need to retrieve the onset of the dive, onset of the bottom phase, length of dive, etc. For years I have been finding these points through visual inspection of the data. It is extremely tedious and in know way efficient. I am interested in expediting this whole process and am more than willing to learn VB...but only IF it is the best approach for this application.I have attached two dives worth of data, so we can see what the data looks like. Each data set can contain from 1 to 8 hours worth of data.
View 5 Replies
May 7, 2010
i just want to ask a question.. what connector does oracle 10g uses?
View 3 Replies
Apr 2, 2011
I'm making an app where people need to log in, these data are on a Oracle 10g XE DB, I know how to access the data, but I don't know how to validate is the query returns something or doesn't (to validate the username and password, of course). I'm using an ODBC with VB.net to connect the DB.
View 1 Replies