16f6c0aecf
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
719 B
Plaintext
43 lines
719 B
Plaintext
== Why is this an issue?
|
|
|
|
Anchored types, i.e. those specified using either ``++%TYPE++`` or ``++%ROWTYPE++``, cannot be constrained. Trying to do so results in the exception ``++PLS-00573: cannot constrain scale, precision, or range of an anchored type being raised.++``
|
|
|
|
|
|
=== Noncompliant code example
|
|
|
|
[source,sql]
|
|
----
|
|
DECLARE
|
|
foo DUAL.DUMMY%TYPE(42); -- Non-Compliant - raises PLS-00573
|
|
BEGIN
|
|
NULL;
|
|
END;
|
|
/
|
|
----
|
|
|
|
|
|
=== Compliant solution
|
|
|
|
[source,sql]
|
|
----
|
|
DECLARE
|
|
foo DUAL.DUMMY%TYPE; -- Compliant
|
|
BEGIN
|
|
NULL;
|
|
END;
|
|
/
|
|
----
|
|
|
|
ifdef::env-github,rspecator-view[]
|
|
|
|
'''
|
|
== Implementation Specification
|
|
(visible only on this page)
|
|
|
|
=== Message
|
|
|
|
Remove this constraint on "xxx".
|
|
|
|
|
|
endif::env-github,rspecator-view[]
|