473,324 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

ORA-01036: illegal variable name/number.

Iam executing the following C# code and it is giving an error at da.Fill(ds); in the code.Please some one help.
Thanks in advance



OracleConnection conn = new OracleConnection(GetConnectionString());

OracleCommand cmd = new OracleCommand("exec GET_DATA", conn);
cmd.Parameters.Add("NO", OracleType.Char, 7).Value = "111" cmd.Parameters.Add("DAT_CURSOR", OracleType.Cursor).Direction = ParameterDirection.Output;


OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
DataView objDV = new DataView();
DataTable objDT = new DataTable();

da.Fill(ds);
objDT = ds.Tables[0];
objDV = ds.Tables[0].DefaultView;
objDV.Sort = strSort;
Repeater1.DataSource = objDV;
Repeater1.DataBind();


conn.Close();
}
Jan 11 '08 #1
4 7203
Shashi Sadasivan
1,435 Expert 1GB
does the procedure GET_DATA take parameters as an input?

could you also specify the error that you get?
copying and pasting the error is the best thing to do
Jan 11 '08 #2
does the procedure GET_DATA take parameters as an input?

could you also specify the error that you get?
copying and pasting the error is the best thing to do
Yes the procedure takes one input parameter based on which it will run a select statement that will fetch results.

The exact error when compiling is "ORA-01036: illegal variable name/number" and the location of the error is da.Fill(ds)
Jan 11 '08 #3
Shashi Sadasivan
1,435 Expert 1GB
have you tried setting the command property "CommandType" to StoredProcedure?

cmd.CommandType = CommandType.StoredProcedure;

you shud do this before da.fill. preferrably after you set all the parameters
Jan 11 '08 #4
have you tried setting the command property "CommandType" to StoredProcedure?

cmd.CommandType = CommandType.StoredProcedure;

you shud do this before da.fill. preferrably after you set all the parameters
Shashi, It worked.Thanks a bunch.
Jan 11 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Galina | last post by:
Hello I have created a trigger not to let records with certain fields null to be inserted into the table: BEGIN IF :new.RUL_CODE is null or :new.FES_UINS_CODE is null or :new.FES_UIO_CALOCC is...
1
by: Park Yeon Jo | last post by:
About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I installed Oracle 8.1.7 on Windows XP Professional. and I wanto connect to that server...
6
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
2
by: mpatel6 | last post by:
I had this error in alert log and my instance was down, anybody can help me? Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc: ORA-07445: exception encountered: core...
0
by: kalpanaanand | last post by:
I am new to Oracle 9i client. i tried to log in but i am getting this error. this is my listenerfile # LISTENER.ORA Network Configuration File: C:\ProgramFiles\oracle\NETWORK\ADMIN\listener.ora #...
5
by: mivey4 | last post by:
Hi, First off, I am aware that this is a very heavily documented error and I have done my homework for throughly researching probable causes before deciding to post my problem here. At this point,...
5
by: Nitvar | last post by:
When i am trying to connect to oracle it is giving me these two errors ORA-12224: TNS:no listener ORA-01034: ORACLE not available I am new to oracle ,plz help I am using solaris 5.6 and...
3
nabh4u
by: nabh4u | last post by:
HI everyone, I an getting the following errors when i execute my procedure. SQL> exec PROCEDURE_NAME BEGIN PROCEDURE_NAME; END; * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error:...
0
by: basmgokul | last post by:
I am using oracle 10g in windows vista.. when starting DB it throws an error Errors in file c:\database\udump\practice_ora_440.trc: ORA-00704: bootstrap process failure ORA-39700: database...
1
by: michael ngong | last post by:
michael.john@gmx.at (Michael John) wrote in message news:<90cc4edd.0306230900.28075193@posting.google.com>... MIchael I you stated the OS and platform that could make it easier to address your...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.