"SET AUTOCOMMIT" in Oracle 
Author Message
 "SET AUTOCOMMIT" in Oracle

Hi to all,

I am searching for a possibility to send an SQL-Command with Clarion 5.5
using the native Oracle driver to an Oracle8 database.

The command is: "SET AUTOCOMMIT OFF"  (or "SET AUTOCOMMIT ON").

When I use the standard-syntax: Table{PROP:Sql} = 'SET AUTOCOMMIT OFF'
an "File System Error" occurred
 (FileError = ORA-00922: Missing or invalid option).

Can anybody help me ?
Thanks in advance for any suggestions !
 Ralf



Tue, 13 Sep 2005 22:26:40 GMT  
 "SET AUTOCOMMIT" in Oracle
Hi Ralf,

you have the same problem as I do.
I use Clarion 5b and the ODBC-Driver instead but I get the same
Fileerror (ORA-00922).

Can't help you, sorry.
Hope there's someone out there with the answer.

By
 Manfred

Quote:
> Hi to all,

> I am searching for a possibility to send an SQL-Command with Clarion 5.5
> using the native Oracle driver to an Oracle8 database.

> The command is: "SET AUTOCOMMIT OFF"  (or "SET AUTOCOMMIT ON").

> When I use the standard-syntax: Table{PROP:Sql} = 'SET AUTOCOMMIT OFF'
> an "File System Error" occurred
>  (FileError = ORA-00922: Missing or invalid option).

> Can anybody help me ?
> Thanks in advance for any suggestions !
>  Ralf



Mon, 19 Sep 2005 19:46:57 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. who set "set tz=....." command orignally

2. string.join(["Tk 4.2p2", "Python 1.4", "Win32", "free"], "for")

3. "Memo" problems with Oracle and CW

4. BEGIN{want[]={"s1o", "s2o", "s2q", "s3q"}

5. Missing AppleScript Command "set language"

6. Setting "checked" property on menu item

7. Set a pause when variable="x"??

8. Meaning of "set clipper=f55"

9. Summer'87 and "set epoch"

10. Help: "Set Focus" in Clipper 5.3

11. can the "chart-speed" be set

12. SET(_SET_PRINTFILE,"LPT1") on Novell

 

 
Powered by phpBB® Forum Software