If I am posting this is the wrong area, I apologize.
I am trying to add a table adapter to one of my datasets. The dataset has oracle as its datasource using ODP.NET. When I put in the query (which works elsewhere) I get this error (Syntax Error: Expecting identifier or quoted identifier)...
So below is the code I wrote yesterday. I don't often work in VB and I haven't had to insert a BLOB before. However, the error at least at this moment isn't BLOB specific but syntax. I'm getting the error from Oracle - 'Missing expression' I can't see what's missing but honestly I've been...
Hi, currently I have text file showing as this
Class_ID, USER_ID, SOURCE_NO
10005:A05:AAA02 <-- this is wrong, I need to compare within text file as well.
Did anyone know how to bulk insert the data I read from text file? it many...
Seeking a Senior Developer with Oracle backend experience for a contract-to-hire position with a gas & oil company in Houston, TX. Please submit resumes to email@example.com. IN-PERSON interview required.
Enterprise Senior Developer:
The position is a programming role with a heavy...
I am having some difficulty coming up with a clean design for inserting new records into an oracle database using VS 2008, Datasets and the TableAdapterManager. The Primary Key of the Oracle table is ID and is defined as a number. My original intention was to create a Before Insert trigger...
does anyone know how to call an oracle procedure without the parametername?
We've got some oracle packages that take like 15 parameters. I'm sick of doing this
Dim pc As New OracleParameterCollection
and then typing
Dim a As New OracleParameter("p1", OracleType.Number)...