I have multiple stores and i need to create a new Stored Procedure in every store
i have created 11 files in a folder and executing them one by one the 9 and 10 is the stored procedure..every thing is working fine but Stored Procedure is creating with errors
error
PROCEDURE 01951.PROCESS_SCANNED_BARCODE_GDN
On line: 1
PLS-00103: Encountered the symbol "" when expecting one of the following:
( ; is with authid as cluster compress order using compiled
wrapped external deterministic parallel_enable pipelined
and when i am running the same in Toad without a single change it's compiling without any error
here is my code
foreach (DataRow row in ds.Tables[0].Rows)
{
try
{
user_id = row["STORE"].ToString();
password = Convert.ToInt32(row["STORE"].ToString()) + 7;
ftp_ip = row["FTP_IP"].ToString().Trim();
constr = "Data Source=" + ftp_ip + "/orcl;User ID=" + user_id + ";Password=" + password + "";
store_con = new OracleConnection(constr);
store_con.Open();
for (int i = 1; i < 12; i++)
{
using (StreamReader reader = new StreamReader("C:\\DTS_Package\\HHT\\" + i.ToString() + ".txt"))
{
try
{
str = reader.ReadToEnd();
store_cmd = new OracleCommand(str, store_con);
store_cmd.ExecuteScalar();
}
catch (Exception ex)
{
}
}
}
str = "INSERT INTO STORES_NOT_CONNECTED VALUES ('" + user_id + "','" + ftp_ip + "','Updated',SYSDATE,'HHT')";
cmd = new OracleCommand(str, con);
cmd.ExecuteNonQuery();
store_con.Close();
}
catch (Exception ex)
{
str = "INSERT INTO STORES_NOT_CONNECTED VALUES ('" + user_id + "','" + ftp_ip + "','" + ex.Message + "',SYSDATE,'HHT')";
cmd = new OracleCommand(str, con);
cmd.ExecuteNonQuery();
}
}