Re: Trouble coverting a Procedure into a "STORED" procedure

Craig B. wrote:

> Thanks Daniel for your help, but that didn't work. I tried many
> variations of "CREATE OR REPLACE PROCEDURE <procedure_name> IS", like
> with "()" or without.

Then start with the basics:

CREATE OR REPLACE PROCEDURE myproc IS

x VARCHAR2(20);

BEGIN
   NULL;
EXCEPTION
   WHEN OTHERS THEN
     NULL;
END myproc;
/

Now that you have compiled that ... start adding your code to the framework until you break it. Then fix what you did wrong.

In the future post your code and the complete ORA- error message including number and text.

HTH

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)