ODAC

TOraScript Class

A component for executing several SQL statements one by one.

For a list of all members of this type, see TOraScript members.

Unit

OraScript

Syntax

TOraScript = class(TDAScript);

Remarks

Often it is necessary to execute several SQL statements one by one. Known way is using a lot of components such as TOraSQL. Usually it is not a good solution. Sometimes it can be performed by anonymous PL/SQL block. But sometimes it does not work. For example, DDL statements cannot be used in PL/SQL. With only one TOraScript component you can execute several SQL statements as one. This sequence of statements is named script. To separate single statements use semicolon (;), slash (/) ,and for PL/SQL - only slash . Note that slash must be the first character in line.

Errors that occur while execution can be processed in the TDAScript.OnError event handler. By default, on error TOraScript shows exception and continues execution.

Inheritance Hierarchy

TDAScript
   TOraScript

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback