Oracle Script

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
degas
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Oracle Script

Post by degas » Mon 10 Jan 2011 19:47

i have a problem whe running the following script using the OracleScript component.

Code: Select all

SET SCANN OFF;

Insert into data
   (column1)
 Values
   ('&value123');
COMMIT;
The strange thing is that if i run it my local machine works fine but when i run it on my server i get the following error:
ORA-00922: missing or invalid option

If i run it on the sqlplus works fine in mi server and my local machine.
The version i am using is 5.35.79

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 12 Jan 2011 15:01

SQL Plus commands are not supported by the OracleScript component. In this case you can safely omit the 'SET SCAN OFF' (or 'SET DEF OFF') option in your script because this is a default behaviour.
We recommend you to use OracleCommand to execute queries with parameters.

Post Reply