Duh! Procedure woes testing mettle. . .

This ought to be simple. But I assume everyone reading this is familiar with Oracle's "finding information as treasure hunt" policy, so you'll understand:

1. Somebody else bought the system; I'm stuck trying to get it going.
2. I want to use stored procedures.
3. All attempts to do so fail: SQL> create procedure foo as ERROR at line 1: ORA-00900: invalid SQL statement
4. So I find in the book I better run "dbmsstdx.sql" first. OK: create package dbms_standard is *ERROR at line 1: ORA-00900: invalid SQL statement

Hmmm. First question: does anybody know what's going on here? Since the documentation says that stored procedures is an option, how can I find out if we have it. Or does the existence of that script imply it's here somewhere.

You won't get money or fame for helping, but the knowledge of saving someone else from the brink of Oracle Insanity. . . .

Thanks in advance.         

Brian Capouch
Networking Specialist
Saint Joseph's College
brianc_at_saintjoe.edu

"You guys quit having such a good time. This is school!!" Received on Sun Apr 21 1996 - 00:00:00 CEST