Oracle Script

[degas]

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]

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.