teemu_selkala
13 years agoOccasional Contributor
Error - ORA-00911: invalid character
Hi,
I have a list of queries in SQL in an excel to be executed in order to test our database. I try to read them out and do the queries with following code but keep getting this error on subject on bolded part, any ideas why?
I have a list of queries in SQL in an excel to be executed in order to test our database. I try to read them out and do the queries with following code but keep getting this error on subject on bolded part, any ideas why?
function checkout()
{
var Conn
var Excel = Sys.OleObject("Excel.Application")
Conn= ADO.CreateConnection()
Conn.ConnectionString="My connection String";
Conn.Open();
Cmd = ADO.CreateCommand();
Cmd.ActiveConnection = Conn;
Cmd.CommandType = adCmdText;
Excel.Workbooks.Open("c:\\querys.xlsx")
var RowsCount = Excel.ActiveSheet.UsedRange.Rows.Count;
for(i=1;i<RowsCount;i++)
{
Cmd.CommandText = Excel.Cells(i,1)
Log.Message(Cmd.CommandText = Excel.Cells(i,1))
// Line below gives the error
RecSet = Cmd.Execute();
}
RecSet.Save("c:\\tietokanta.xml",1)
Conn.Close();
Excel.Quit()
}