Thanks. To get it to run from SQL Plus or VFP, and compile correctly, you add a / before the second CREATE OR REPLACE. That submits the CREATE PACKAGE to the compiler. Then you create the pkg body and end it with a / to submit it to the compiler.
Now on to why I can not get the call to the SP to work.
>Mark,
>How are you running it? If using SQL Plus+, I don't think you can have multiple CREATEs executing at the same time. When I created an SP builder, I had to send my DDL statements separately. It was a big PITA. The same builder creates SPs in Oracle or SQL Server and SQL Server allowed multiple blocks simply by breaking them up with a GO command. I thought the ; was supposed to do the same thing in Oracle. WRONG!!!
>
>HTH.
Mark McCasland
Midlothian, TX USA