using orcle server client

[brettokumar]

hi i my pro im using orcale client server while i m using update query i run properly. but instead of query im using storeprocedure i can not execute it display error like 'invalid sql statement ' if im execute that procedure in my pl/sql it run properly my code is like in my sapx.cs file string Qry = "Exec user_insert_proc('BW100000906','127.0.0.1','acibre','BrettoKumar','09006833242hijklm', 'bretto_be@yahoo.com',2,'abraham','Bretto','Abraham','1','27-Apr-1971','','22-Sep-2008 12:37:55 AM','22-Sep-2008 12:37:55 AM','ttk','alwarpet','620001','chennai','tamilnadu','BW','04411-123456789','0441-123456789','91-98947455711','','','8237536982482857233565195638026419924352543044988390181159607082248527607624911769985440292861738021','22-Sep-2008 12:37:55')"; public string exeQry(string qry) { if (Con.State == ConnectionState.Closed) { Con.Open(); } cmd = new OracleCommand(qry, Con); cmd.ExecuteOracleNonQuery(); Con.Close(); } it display error like ORA:00900 invalide sql statement

with regards, bretto

[Abhishek Sur]

The error is thrown from oracle. Please check if the query you have prepared is running on actual oracle console or not.

Abhishek Sur

[N a v a n e e t h]

brettokumar wrote:

'invalid sql statement '

Error message is clear, isn't it?

brettokumar wrote:

string Qry = "Exec user_insert_proc('BW100000906','127.0.0.1','acibre','BrettoKumar','09006833242hijklm', 'bretto_be@yahoo.com',2,'abraham','Bretto','Abraham','1','27-Apr-1971','','22-Sep-2008 12:37:55 AM','22-Sep-2008 12:37:55 AM','ttk','alwarpet','620001','chennai','tamilnadu','BW','04411-123456789','0441-123456789','91-98947455711','','','8237536982482857233565195638026419924352543044988390181159607082248527607624911769985440292861738021','22-Sep-2008 12:37:55')";

What a disaster. Read about SQL Injection and change this to parametrized queries.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions