ref_code tables not required but generated
Hi.
I don't use any ref_codes tables in my application. But when generating table API I always obtain this part of the *.PKB script for every table:
PROCEDURE validate_domain(cg$rec IN OUT cg$row_type,
cg$ind IN cg$ind_type DEFAULT cg$ind_true)
IS
cursor cDomain( p_columnName varchar2 ) is -- B1158144 : added
SELECT RV_LOW_VALUE, RV_HIGH_VALUE
FROM CG_REF_CODES
WHERE RV_DOMAIN = p_columnName;
dummy NUMBER;
no_tabview EXCEPTION;
PRAGMA EXCEPTION_INIT(no_tabview, -942);
BEGIN
NULL;
EXCEPTION
...
END validate_domain;
with the error message that the CG_REF_CODES table doesn't exist when applying the script to database. How to avoid the cursor definition? I have the DS - 9.0.2.2 version Designer. Everything was OK in previous version.
The workaround is to create CG_REF_CODES table empty but I don't want to have it. Thank you for any advice.
The "Automatic creating of REF_CODES tables" is unchecked.
Ivan Virag