Oracle Script

Oracle Script

Postby 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
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Postby 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.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle