Need a little more info...
How are you starting sqlplus? (ie sqlplus scott@po)
Is your ORACLE_HOME and ORALCE_SID environment variables set?
What is in sqlnet.ora for default_domain?
I'm having this exact same problem!!! No fix yet. Here's what I've done so far. I removed the old JRE 1.1.6 (from blackdown from prior attempt to install 8.1.5.) I have JDK 1.3.1.02 installed. I'm going to try removing it and and installing 1.2.2. Don't you like how the release notes say...
Did you change <ProcedureName> to the real name of your stored procedure? Are you logging into oracle as the owner of the stored procedure? You can run this query to get the name of your procedure as its saved in oracle...
select object_name
from user_objects;
Learned about this site at a recent Oracle User Group meeting. Check out http://otn.oracle.com/obe. Its 'oracle by example'. It has tutorials for doing different types of things in 9i and its FREE!
http://www.orafaq.com/faq2.htm is another good site.
Save this script (see below) in a file called 'grab_procedure.sql'. Call it from sql*plus (ie @grab_procedure <procedure-name> ). It will spool your procedure to a text file named '<procedure-name>.sql' along with grants for the proc. Other tools are much easier to use. I use TOAD...
Oracle is the more robust of the two. Oracle is the only RDBMS to provide true read consistancy without blocking readers. Example - you start a long query for a report. After you start the query, but before it completes, other users update some of the same rows you are querying against. In...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.