Passing a Cursor from Procedure to a Package Spec using REF cursor

[Mnemonical]

your procedure has two parameters, doesn't it? So, you have to pass two parameters, you passed only one ('Smith').

eg ('Smith', variable)


F.