Re: newbie question on procedures

Jim,

  First, to get a better error message than "Warning..." execute the following: "show errors;" This will list the errors on the last compliled procedure. If you have more than one in a script execute this: "show errors procedure NAME_OF_PROCEDURE". This will give you the same listing as the first command but on the specific procedure NAME_OF_PROCEDURE.   Second, you can not use a simple select statement in a procedure and get an anwser back. You must place the results into variables then use the DBMS_OUTPUT package procedure to display it on the screen.

  Refer to the Programmers Guide for PL/SQL version 2.x for examples of PL/SQL procedurs and the Application Development Guide for standard supplied packages such as DBMS_OUTPUT.

Hope this gets you started

D. Kim Hughes
Managing Consultant
DRT Systems
Houston, TX
(713)868-5537 Received on Tue Feb 06 1996 - 00:00:00 CET