Stack Overflow
Stack Overflow

Questions tagged [ora-01036]

ORA-01036: illegal variable name/number

15 questions
17
votes
2 answers

Usage of Oracle binding variables with LIKE in C#

As part of an effort to stop using dynamic SQL generation and encourage use of bind variables, I am running into some problems. I am querying an Oracle 9i database from an ASP.NET page using Oracle Data Providers for .NET The query is sql = "SELECT…
PJ.
  • 391
  • 1
  • 3
  • 11
8
votes
3 answers

ORA-01036; illegal variable name/number

I have the following insert query include("ORCLconfig.php"); $addAclaim = oci_parse($conn, "INSERT INTO claims_accidents (ID, CLAIM_NUMBER, DATE_OF, TIME, LOCATION, PURPOSE, WEATHER, ROAD, STREET_LIGHTS, SPEED_LIMIT, SPEED_PRIOR, SPEED_AT_MOMENT,…
jampez77
  • 5,012
  • 7
  • 32
  • 52
2
votes
3 answers

UPDATE statement in Oracle

We are building a client program where parameters for storage in a web server with Oracle backend are set in the .Net client program and uploaded as a dataset via webservice. In the webservice code, data is read from the dataset and added to UPDATE…
stephen falken
  • 21
  • 2
2
votes
1 answer

ora-01036 illegal variable name/number ExecuteNonQuery call usingVB.Net

I'm having an issue executing an Oracle query via .NET. I'm quite new to calling Oracle commands from .Net, (i'm coming from a mySQL background) so any help is much appreciated! I first build a query string... declare pDate date; pErrorCode…
Michael B
  • 109
  • 2
  • 13
2
votes
2 answers

Constructing a good search query using system.data.oracleclient

I am constructing a search function in a class to be used by several of our asp pages. The idea is simple, take a search term from the user and query the database for the item. Currently I am doing this the wrong way, which is vulnerable to SQL…
Maximillian
  • 743
  • 2
  • 22
  • 41
1
vote
1 answer

Delphi7 master detail relations query results in ORA-01036

I'm using Delphi7, Devart's dbExpress driver 4.70. I drop two TSQLTables (call them A and B), two TDataSetProviders (dspA and dspB), two TClientDataSets (cdsA and cdsB), two TDataSources (dsA and dsB) and two DBGrids (gridA and gridB). Everything…
Francesco
  • 1,742
  • 5
  • 44
  • 78
1
vote
1 answer

ORA-01036: illegal variable name/number on PL/SQL script

I'm fairly new to the PL/SQL game and I'm attempting to come up with a short script to create logins and grant read-only/read-write privs (making the necessary grants as necessary). However, I am encountering variable scoping issues with it. Can…
yungun
  • 13
  • 1
  • 3
0
votes
0 answers

How to control errors of the oracle db library in javascript. ORA-01036: Illegal variable/number?

I am performing an insert using literal objects to a table with more than 50 fields in my oracle database, my message is "ORA-01036: Illegal variable/number?" How can I know in which column or in which parameter of those sent the program threw the…
Juan Carlos Benavides
  • 1
0
votes
0 answers

cx_oracle ORA-01036: illegal variable name/number

I have this group of python scripts where I do an API call, merge the resulting df together, then output to a table in an Oracle db. This exact script is working perfectly in three other scripts configured same, except a different API, but in this…
JBSilverAge
  • 1
0
votes
1 answer

ORA-O1036: Illegal variable name/number

There are alot of posts related to this question but no one work for my case. I am using oracle database with C# on visual studio void addUser() { OracleCommand cmd = new OracleCommand(); string query ="INSERT INTO users (user_id,…
Jamal Ahmad
  • 1
  • 1
0
votes
1 answer

Oracle Merge statement ORA-01036 error c# ado.net

This is more of a caution than a question, as it will save someone a lot of headaches if they encounter this situation. I faced the cryptic ORA-01036 error in my merge statement when I set command's BindByName property to true. If I set BindByName…
Vijay Jagdale
  • 2,321
  • 2
  • 18
  • 16
0
votes
2 answers

Java JDBC Oracle 9i upgrade to 10g issues

We have just upgrade from oracle 9i to 10g and a database query I have works with the 9i client but not the 10g. Nothing in the query has changed. I get the following error: java.sql.SQLException: ORA-01036: illegal variable name/number Not really…
user16208
  • 305
  • 1
  • 5
  • 13
0
votes
1 answer

ORA-01036 error on update query using c#

I am getting error when I update a number and try to get back that number. I have already googled for this error but all codes suggest the same solution I have but still I get this error. Oracle.DataAccess.Client.OracleException ORA-01036: illegal…
riz
  • 69
  • 1
  • 7
0
votes
0 answers

ORA-01036: illegal variable name/number error on parameter in SELECT

I am trying to populate a series of dropdown lists in a GridView. In the RowDataBound event, I call based on other info in the gridviewrow to get the items for populating dropdowns in the row. I am getting "ORA-01036: illegal variable name/number…
monkeypushbutton
  • 196
  • 1
  • 9
  • 21
0
votes
1 answer

ORA-01036: when using Insert command on datasource

Trying to set up an insert statement in asp.net. My insertCommand is as follows: InsertCommand="INSERT INTO DVD VALUES (DVD_SEQ.NEXTVAL, :DVD_TITLE, :RENTAL_COST, :RATING, :COVER_IMAGE)" The code for the insert parameters are: …
Linky
  • 11
  • 1
  • 5