Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 77
- Joined: Mon 16 Feb 2009 18:36
- Location: Argentina
i have a problem whe running the following script using the OracleScript component.
Code: Select all
SET SCANN OFF;
Insert into data
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
- Site Admin
- Posts: 8247
- Joined: Thu 14 Aug 2008 12:44
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.