Avaya Business Communications Manager - PeriRDB Manual de usuario descargar pdf (Pagina 28)

PeriRDB User’s Guide

Page 28

Debugging the SQL Command in PeriSQL

If PeriSQL cannot successfully execute the SELECT command, it provides an error

message to indicate a logic or syntax error.

A parse error indicates a syntax error in the SELECT statement. PeriSQL indicates the

location of the syntax error. For example:

A“no data” message indicates that the query did not retrieve any data. The query

successfully executed, but no data matched the query. For example:

Reported Issues

PeriSQL does not support Oracle reference cursors.

Using Stored Procedures, Functions, and Triggers

You can use PeriSQL to display templates of Procedures, Functions, and Triggers

defined for each user (see Displaying Predefined Procedures, Functions, and

Triggers on page 29). You can also use PeriSQL to write Procedure and Function

declarations to an SQL application (see Implementing Procedures and Functions on

page 31).

offset 1

offset 20

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 59 60

Sin comentarios

Avaya Business Communications Manager - PeriRDB Manual de usuario Pagina 28