Dynamic SQL in a stored procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Dynamic SQL in a stored procedure

  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Dynamic SQL in a stored procedure

    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

    Any assistance would be appreciated.

    Thanks
    Murray Sobol
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width