Need simple stored procedure for JDBC test

Folks:
I'm using Oracle Enterprise Manager 8.0.5 on NT 4.0 Assume I have some table named "Fred"

I want to create a stored procedure or function that I can call from JDBC that returns all of the rows of Fred. I don't know what the DDL would look like, although I know its something like:

create function <returnType>? readFred() BEGIN
  return select * from Fred;
END Can someone tell me what the DDL would be to create either a stored procedure or function to do this?

Email replies appreciated.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 02 1999 - 08:39:12 CDT