All about Oracle anonymous PL/SQL blocks

The only even slightly tricky thing to remember is that the ADO Command object doesn't have a ConmandType for anonymous PL/SQL blocks, so we have to use the one for plain text, adCmdText (with a value of 1). The CommandText property holds the string in proper format. This format is discussed la...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Active Server Developer's Journal Jg. 6; H. 4; S. 11
1. Verfasser: Hetzel, Al
Format: Trade Publication Article
Sprache:Englisch
Veröffentlicht: Louisville Element K Journals 01.04.2002
Schlagworte:
Data base management systems
Guidelines
Servers
Structured Query Language-SQL
Systems development
World Wide Web
United States
US
ISSN:1093-412X, 1539-0330
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The only even slightly tricky thing to remember is that the ADO Command object doesn't have a ConmandType for anonymous PL/SQL blocks, so we have to use the one for plain text, adCmdText (with a value of 1). The CommandText property holds the string in proper format. This format is discussed later. From here on, all anonymous PL/SQL code will be put in the Oracle format since the code example above can be used to run any valid block of code.
ISSN:1093-412X
1539-0330