
Inline adoc files when they are included exactly once. Also fix language tags because this inlining gives us better information on what language the code is written in.
43 lines
628 B
Plaintext
43 lines
628 B
Plaintext
== Why is this an issue?
|
|
|
|
Some types cannot be constrained, and attempting to do so results in the exception ``++PLS-00566: type name "..." cannot be constrained++`` being raised.
|
|
|
|
|
|
=== Noncompliant code example
|
|
|
|
[source,sql]
|
|
----
|
|
DECLARE
|
|
foo BLOB(42); -- Noncompliant - raises PLS-00566: type name "BLOB" cannot be constrained
|
|
BEGIN
|
|
NULL;
|
|
END;
|
|
/
|
|
----
|
|
|
|
|
|
=== Compliant solution
|
|
|
|
[source,sql]
|
|
----
|
|
DECLARE
|
|
foo BLOB;
|
|
BEGIN
|
|
NULL;
|
|
END;
|
|
/
|
|
----
|
|
|
|
ifdef::env-github,rspecator-view[]
|
|
|
|
'''
|
|
== Implementation Specification
|
|
(visible only on this page)
|
|
|
|
=== Message
|
|
|
|
Remove this "xxx" constraint.
|
|
|
|
|
|
endif::env-github,rspecator-view[]
|