GENERATION OF DERIVATION PROCEDURE FAILS
(Doc ID 459389.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Clinical - Version 4.5.1 to 18.104.22.168 [Release 4.5.1 to 4.5.2]
Information in this document applies to any platform.
This problem can occur on any platform.
Unable to generate a derivation procedure. In custom code pre-detail section of a derivation procedure have placed the following code :
select count(*) into v_count
When trying to generate the procedure, get the message :
PACKAGE BODY, 120/18, PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY, 119/13, PL/SQL: SQL Statement ignored
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