I am trying to rewrite a Procedure to use dynamic SQL
I have attached my procedure.
When I try to compile it I get this error:
•Project: C:\Users\murray.OLF\AppData\Roaming\SQL Developer\system4.2.0.16.356.1154\o.sqldeveloper.12.2.1.16.356.1154\projects\IdeConnections#Oracle12 c+-+D19.jpr
•Oracle12c - D19
•Error(405,5): PL/SQL: Statement ignored
•Error(406,13): PLS-00302: component 'AS_BIN_NUMBER' must be declared