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
679 B
Plaintext
43 lines
679 B
Plaintext
== Why is this an issue?
|
|
|
|
String data types, such as ``++VARCHAR2++`` or ``++NVARCHAR2++`` require a size constraint. Omitting the size results in the exception ``++PLS-00215: String length constraints must be in range (1 .. 32767)++`` being raised.
|
|
|
|
|
|
=== Noncompliant code example
|
|
|
|
[source,sql]
|
|
----
|
|
DECLARE
|
|
foo VARCHAR2; -- Noncompliant - raises PLS-00215
|
|
BEGIN
|
|
NULL;
|
|
END;
|
|
/
|
|
----
|
|
|
|
|
|
=== Compliant solution
|
|
|
|
[source,sql]
|
|
----
|
|
DECLARE
|
|
foo VARCHAR2(42); -- Compliant
|
|
BEGIN
|
|
NULL;
|
|
END;
|
|
/
|
|
----
|
|
|
|
ifdef::env-github,rspecator-view[]
|
|
|
|
'''
|
|
== Implementation Specification
|
|
(visible only on this page)
|
|
|
|
=== Message
|
|
|
|
Specify this variable's size.
|
|
|
|
|
|
endif::env-github,rspecator-view[]
|