ADO Execute not reading a line of SQL code?

Question

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);

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?

mkoryak · Accepted Answer · 2010-04-15 14:43:34Z

1

It seems to me that your problem is not with jscript or ado.net, but your sql in that sql file is invalid.

If you look at this page for example: http://webcache.googleusercontent.com/search?q=cache:N0n7PtpJH4gJ:www.daniweb.com/forums/thread197500.html+ORA-00922:+missing+or+invalid+option&cd=3&hl=en&ct=clnk&gl=us&client=firefox-a

you will see that everyone who got that oracle error got it because of bad syntax.

does that sql execute in a sql client?

answered Apr 15, 2010 at 14:43

mkoryak

58.1k64 gold badges204 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

llaskin Over a year ago

Actually it turned out I was sending SQL+ statements to something that didn't need the serverout size set.

llaskin · Accepted Answer · 2010-04-15 15:51:05Z

1

It turned out that I was sending a SQL+ statement to a pure SQL environment. This caused it to error on the Set Serverout statement

answered Apr 15, 2010 at 15:51

llaskin

8092 gold badges11 silver badges24 bronze badges

Collectives™ on Stack Overflow

ADO Execute not reading a line of SQL code?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related