ADO Execute not reading a line of SQL code?

Posted by llaskin on Stack Overflow See other posts from Stack Overflow or by llaskin
Published on 2010-04-15T14:29:25Z Indexed on 2010/04/15 14:33 UTC
Read the original article Hit count: 142

Filed under:

jscript

|

JavaScript

|

ADO.NET

My code is below:

  var statement = "test_oracle.sql";
  F = aqFile.OpenTextFile(statement, aqFile.faRead, aqFile.ctANSI);
  F.Cursor = 0;
  while(! F.IsEndOfFile()){
    s = F.ReadLine();
    oResult = Project.Variables.oConnection.Execute_(s);
    CheckResult(oResult, "Unable to run SQL script to add documents");

The first line that "s" reads is: set serverout on size 10000

An error is returned as "ORA-00922: missing or invalid option"

Can anyone provide guidance?

© Stack Overflow or respective owner

Related posts about jscript

Reference methods defined in one JScript file from another JScript

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing some server-side scripts using jscript and WSH. The scripts are getting quite long, and some common functions and variables would fit better in a general library script which I included in my various script instances. But, I cannot find a way reference one JScript file from another.… >>> More
JScript.NET private variables

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm wondering about JScript.NET private variables. Please take a look on the following code: import System; import System.Windows.Forms; import System.Drawing; var jsPDF = function(){ var state = 0; var beginPage = function(){ state = 2; out('beginPage'); } var out = function(text){ … >>> More
Instantiating a System.Threading.Thread object in Jscript

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to create a new System.Threading.Thread object using Jscript, but I can't get the constructor to work. If I just do the following, var thread = new Thread( threadFunc ); function threadFunc() { // do stuff } then I get error JS1184: More than one constructor matches this argument… >>> More
Book Review: JScript.NET Programming

as seen on Internet.com - Search for 'Internet.com'
Is this book for you? Check out Jim Maioriello's review of this new book by Essam Ahmed on JScript.NET. >>> More
Memory leak with Microsoft.JScript.Eval.JScriptEvaluate?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm evaluating some javascript with Microsoft.JScript.Eval.JScriptEvaluate() and I noticed from my memory profiler that there are a large number of System.String left allocated by Microsoft.JScript.HashtableEntry. Microsoft.JScript.Eval is a static class, does anyone know what class is holding these… >>> More

Related posts about JavaScript

CHAT ROOMs 7 by 6

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for chatroom on one page with 7 loggedin users and 6+rows for say 42 users.these users will keep on adding wthnew users.Need urgent help.A PRETTY UNUSUAL Q FOR MOST OF U.What is MORE REQ new features: Usernames are unique to users currently chatting You can see a "currently chatting"… >>> More
Integrating JavaScript Unit Tests with Visual Studio

as seen on Stephen Walter - Search for 'Stephen Walter'
Modern ASP.NET web applications take full advantage of client-side JavaScript to provide better interactivity and responsiveness. If you are building an ASP.NET application in the right way, you quickly end up with lots and lots of JavaScript code. When writing server code, you should be writing… >>> More
Has Javascript developed beyond what it was originally designed to do?

as seen on Programmers - Search for 'Programmers'
I've been talking with a friend about the purpose of Javascript, when and how it should be used, etc. He quoted that: JavaScript was designed to add interactivity to HTML pages [...] JavaScript gives HTML designers a programming tool HTML authors are normally not programmers… >>> More
PHP, javascript, single quote problems with IE when passing variable from ajax post to javascript fu

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I have been trying to get this to work for a while, and I suspect there's an easy solution that I just can't find. My head feels like jelly and I would really appreciate any help. My main page.php makes a .post() to backend.php and fetches a list of cities which it echoes in the form of: <li… >>> More
Javascript in XSL that is loaded by Javascript

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there anyway to have javascript run when a XSL sheet has been applied to an XML file by Javascript? I am using a JQuery plugin to apply the sheet to the xml but the javascript that is located inside of the XSL file will not run. I put the Javascript at the bottom of the file and it still does… >>> More