ODAC (V9.5.15) study notes (11) Toraencryptor, Torapackage and Toraalerter

Toraencryptor

Name	Type	Description
Dataheader	Tcrencdataheader	Some additional information is placed into the encrypted data, including: Ehnone no additional information Ehtag GUID and randomly generated initialization vector data Ehtagandhash Hash, GUID, and randomly generated initialization vector data
EncryptionAlgorithm	Tcrencryptionalgorithm	Specifying the encryption algorithm
HashAlgorithm	Tcrhashalgorithm	Algorithm for specifying hash
Invalidhashaction		Specifies the action to take when the hash algorithm has an exception
Password		The original password required to generate the key
Setkey		Setting the key directly will clear the password

Torapackage

Name	Type	Description
PackageName		Package Name
Params		Parameters of the package
Execproc		Executes the stored procedure or function specified in the package, where the parameters are given in the order of the parameters of the stored procedure
Execprocex		Executes the stored procedure or function specified in the package, where the parameters are given by the specified parameter name, rather than in order
Variablebyname		Gets the variable object (tvariable) in the package based on the variable name and makes the relevant operation

Toraalerter

Name	Type	Description
Active	Boolean	Activating message registration and listening
Autocommit	Boolean	Whether the Oracle database is automatically submitted when a message is sent using the Sendevent method
Autoregister	Boolean	Whether to register automatically when the database is connected
Events	String	The name of the registered message or pipeline
EventType	Teventtype	Message types, including: Etalert Broadcast Messages Etpipe pipeline message, specifying that the thread receives
Interval	Integer	If greater than 0, the thread is started after timeout after waiting for the specified number of seconds
TimeOut	Integer	Timeout time to wait for message (seconds)
GetMessage		Get messages in Message Queuing
Nextitemtype Nextmessagetype		The type of the next message in Message Queuing
Packmessage		The message is placed in the local buffer of the pipeline, the buffer is up to 8192 bytes and is not sent at this time and needs to be called Sendpipemessage to send
Unpackmessage		Reclaims a message from a local buffer in the pipeline
Sendpipemessage		Sends all messages for the pipeline buffer to the specified pipeline
Purgepipe		Clears all received and existing pipeline messages in the local buffer
Sendevent		Send a broadcast message
Start		Start message Listening
Stop		Stop message Listening
OnEvent		Triggered when a message is received
OnError		triggered when an exception occurs when a message is received
OnTimeOut		Triggered when timeout occurs

ODAC (V9.5.15) study notes (11) Toraencryptor, Torapackage and Toraalerter