Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ref_code tables not required but generated

viragiSep 3 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2002
Added on Sep 3 2002
0 comments
443 views