|
I am stuck on a step in below script. It is reading from a text file , picking up a value, evaluating it and based ont the value returned , updating oracle table ( using SQLplus ) with one of the value returned. All thing apart from BODY of IF and ELSE is working. So issues are either with connection or with datapassing Please help me
(comments are locked)
|
|
Use SSIS to open and read the file, or We dont have Microsoft SQL server 2005, we are using Oracle SQL*Plus
Apr 10 '12 at 09:38 AM
PriyankaKaushik
You tagged your question 'sql-server-2005', so I answered in context. Sorry. I'll retag 'oracle'
Apr 10 '12 at 09:40 AM
Kev Riley ♦♦
(comments are locked)
|


I do not know how this script is going to work. But I can see you assigning value to the cmdString, but no execution? I remember one of the ways to do this, is/was to use ADODB.Connection, connection string etc. After opening connection to Oracle, execute the specific command, close the connection and so on. I guess you can google to find it somewhere.