ORA-04062 Sys.Dbms_sql Pkg Signature Error In Form Generated With Soft-Lov (Doc ID 338921.1)

Last updated on MAY 02, 2016

Applies to:

Oracle Designer - Version: 9.0.2 and later   [Release: Designer 9i and later ]
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 06-Okt-2011***


-- Upgraded from Designer -6i to 9i
-- Switching the domain and column to use soft-LOV functionality (dynamic list = Yes). Then
generate ref-codes table and its contents. Regenerate forms. The resulting code has a library
call to do soft-LOV validation. The generated form was compiled and run
against the same 9.2.0.5 database.
-- ORA-04062 - SYS.DBMS_SQL PKG SIGNATURE ERROR IN FORM GENERATED WITH SOFT-LOV

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms