I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID1 52 83 5
e.g. SQL Table name DispTbl
[Code].....
I will try and explain my problem as simply as I can
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
CODE:
What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.
I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.
Below is the code for doing this in the same datasource:
Code:
I am using VB.Net 2005, just for info
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID
1 5
2 8
3 5
[code]....
In my code I have an Oracle command that contains an INSERT statement. Here's a snippet from my SQL:
"'," & "To_Date('" & Format$(dtDateTime_Stamp, "MM/dd/yyyy hh:mm") & _
The value of strDateTime_Stamp is #1/19/2011 9:42:22 AM# I'm getting an error ( "ORA-01830: date format picture ends before converting entire input string") because I don't know how to correctly assign the AM/PM tag on the end -- you'll notice it just says "MM/dd/yyyy hh:mm" in my code. I've tried a bunch of different things but nothing works. I also find it odd that if I change the "MM/dd/yyyy hh:mm" to "mm/dd/yyyy hh:mm" (little m for month) it gives me a 42 for the month value, not a 1. The capital M's fix that but I'm curious to know why.how to I get it to show the AMPM on the end?
I have the following insert into statement. What I want to do is insert the values to gprdsql.TblOracleNos if TxtOracleNo is not empty, therefore if a user logs on and fill the textbox the values are saved to the table. However, if the oracle number exists in gprdsql.TblOracleNos (i.e, the values ) it should not insert the values, presently it creates the same record again with same values (when the save button is clicked) and this creates duplication. Instead probably bring a pop up message "Oracle number already exists. [Code]
View 6 RepliesI have a textbox and a datagrid. I am trying to enter a last name into the textbox and have that return the entire record from that last name into the datagrid from an oracle database. The code below currently returns all records in the table and is not searching by the last name. Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myString As String
[code].....
I have the following Stored Procedures create or replace PROCEDURE WEB_AC
[Code]...
First one: At some point in the application I have the valor parameter (of the visual Basic Function) as a string with spaces that is something like "some string with spaces". When this happens, the stored procedure don't update the table. If I execute the SP directly in the DB (with SQL Developer) all works fine. I know it has something to do with the string missing some quotes(') but I haven't make it work yet. Some ideas on this?
Second problem: Sometimes, when debuging the application, if I interrupt the execution, I start getting the ORA-24338 'statement handle not executed' error for hours every time I try to execute it again. I believe it has something to do with an open transaction. But honestly, as I'm new in working with Oracle, I really have no idea what the problem could be.
[Code]...
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 RepliesI 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 Repliescan 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 RepliesHow to fetch data from SAP r3 to Oracle with .net?
View 1 RepliesHow to access data from Ms-Acess and oracle?
View 4 RepliesI developed an application with old VB form and binding the data from Oracle database into VB form. Actually, I tried to bind the data more than 35000 records in to grid. But, it takes more than half an hour and also form was hanged and there is no output. Can you please let me know the solution to fix it and bind the data without any hang in my application. What are the steps to be followed to fix it?
View 1 RepliesIs there a way to transfer huge amount of data in a single shot from vb.net to Oracle database? I have a couple of thousands of records in my vb.net code which I want to update to Oracle database. What I do currently is, call a stored procedure in database once for each of those records. This would end up calling the stored proc couple of thousand times, which is highly inefficient.
View 2 RepliesSo I have an application that queries a database for something like a social security number. Originally, the connection was established programmatically using ODBC. Now, I want to use the data source option built into Visual Studio.
View 2 RepliesI have a table with a blob field that stores photos in jpg format. Is there any way to direct fill the Dataset with the OracleDataAdapter?
Like:My code in vb.net
Dim oAdp As OracleDataAdapter Dim v_oDs As DsSubRegistro <- My Dataset
oAdp = New OracleDataAdapter(myConnection.sqlCmd("SELECT * FROM ..."))
With oAdp.TableMappings.Add(Common.DbDataAdapter.DefaultSourceTableName, v_oDs.Foto.TableName).ColumnMappings
[Code]...
I need to code the following:
1.Connect to an Oracle database.
2.Execute a query.
3.Insert the query result into an Access database table.
how can i import a Excel sheet Data into my oracle10g Database using vb.net coading..
View 1 RepliesI have a VB.Net application that populates an Oracle 11g global temporary table. I can see data in the temporary table by loading it into a grid and everything looks correct.However, when I call an Oracle stored procedure from VB.Net that would manipulate the data in this temporary table, the stored procedure reports that my temporary table is empty.I understood that data in an Oracle global temporary table should be visible to all sessions.
View 1 RepliesI had a datagridview with databound. I want to write a coding is when user click at any cell of the datagridview, then it will get the whole data of the row and save it into oracle database.
View 7 RepliesHere's a part of XAML of the application I'm working on:
<ListView Name="lsvCustomerDetails" ItemsSource="{Binding myDataTable}">
<ListView.View>
<GridView>
[Code].....
Is this code correct to fill this table? If not, why? Honestly, I've found several perspectives on how to do this sort of thing, some of which are linked below:
From switchonthecode
From csharpcorner
From Allen Mack's blog
Checking data for login form with oracle xe database
View 1 RepliesI am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does anyone know a cleaner & more efficient way that looping through the ranges creating & executing insert statements?
View 3 RepliesI have a table in Oracle that has a column with the Long data type. I create a simple recordset and bind it to a gridview.
Me.grdFollowup.DataSource = rsDataSet
Me.grdFollowup.DataBind()
All of the columns populate correctly except for the Long column. It returns a null for all rows. I have tested the SQL statement in Toad and it works perfectly. how to get an Oracle Long data type to populate in a gridview? This is driving me nuts
Firstly I've the data in csv(delimeted file) that file in exponential number and need to convert to integer( for example [3.9888e+003, 1.0093e+002] ..need to convert to 3989,1009). how to convert it in vb2008.
then send it to datagridview
I've the data in Datagridview (2 column - wavelength, absorbance) and i need to display in text box based on some reference. let say my first reference (soot it has wavelength value plus minus 2000 (range 1998 until 2002), 2nd ref NO2 plus minus 1630 (range 1628 until 1632) and others ref.
Firstly the system will find the specified wavelength in column1 (datagridview). if wavelength(column1) found in that range it will display the value in the textbox (column2- absorbance). then the information in the textbox, need to be save in oracle.
Why does the code below cause a memory leak when executed? The error only happens when I use Microsoft Visual Studio 2005 or 2008 in vb.net language. If I use C # is, there is no problem.
Dim strCon As String = "data source=SRV-10G;user id=Test;password=1234"
dim factory as DbProviderFactory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
Dim conexao As IDbConnection = factory.CreateConnection
conexao.ConnectionString = strCon
[Code]....
I try to show my table data type in datagridview vb.net.[code]I try login using username "system". When I run this code, I got error message "ORA-00900: invalid SQL statement".
View 2 RepliesI try to show my table data type in datagridview vb.net. Here is the sample code :
oradb = "Data Source=(DESCRIPTION=" _
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" & txtServer1.Text & ")(PORT=" & port1.Value & ")))" _
[code]....
Trying to insert 315K Gif files into an Oracle 10g database. Everytime I get this error "ora-01460: unimplemented or unreasonable conversion requested" whe I run the stored procedure. It appears that there is a 32K limit if I use a stored procedure. I read online that this does not apply if you are doing a direct insert, but I do not know how to create the insert string for a Byte Array. This is a thick client running on the server so not worried about SQL Injection attacks.
View 1 RepliesI have the below mentioned code in a seperate class file for establishing connection and carry out DB transactions. I have an issue where multiple connections being opened which sometime exceed the connection pool. When I stepped through the code I found that there are codes which call ConnectDB() in a loop without calling DisconnectDB(). But I expected that the condition OraConn.State = ConnectionState.Closed should handle the situation. Somehow the condition is always satisfied hence openning another set of connection. Can you suggest where am I going wrong and also what best practice can be adopted here?
[Code]...
The connection is again opened in function updData(). While I understand that it has to be closed correctly but keeping tab on every developer is not possible. Hence I want to control it directly from the connection class by using the same connection but the condition If OraConn.State = ConnectionState.
UPDATE I have put the code in UpdateDB under a Using block and removed call to ConnectDB and DisconnectDB from function like InsertData(...). It seems that the issue has been resolved. But I would like to know in case of exception will the connection remain open? and also OraConn is a public variable defined outside Using block so will it be disposed of by the GC?
[Code]...