My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.