If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > Simple PL/SQL Block Error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-18-01, 09:24
Blevels Blevels is offline
Registered User
 
Join Date: Sep 2001
Location: Akron
Posts: 11
Question Simple PL/SQL Block Error

Simple PL/SQL Block Error: PLS-00103 ORA-06550

Logged in as sys/oracle as sysdba
Operating System: Windows 2000 Pro

BEGIN
-- (any PL/SQL code)
SHOW SGA
END;

This Error seems common. Any Solutions?
Reply With Quote
  #2 (permalink)  
Old 12-18-01, 15:55
alligatorsql.com alligatorsql.com is offline
Registered User
 
Join Date: Jul 2001
Location: Germany
Posts: 189
Hello,

what is SHOW SGA ???

I think, this is not a valid command

Greetings
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com
Reply With Quote
  #3 (permalink)  
Old 12-19-01, 07:47
Blevels Blevels is offline
Registered User
 
Join Date: Sep 2001
Location: Akron
Posts: 11
Lightbulb Reply

SHOW is sqlplus command, SGA referes to the instance.

This doesn't matter. If I use NULL;, I'll recieve the same
results or any other lines of code between BEGIN..END;.

This problem doesn't occur in the database setup by the
Oracle 8i install. This problem only occurs in the database
that I setup. One might think that there maybe a problem
in my setup but I'm currently taking courses for the OCP DBA.
My instructure could not figure this one. I have the same problem
I my OCP DBA practice labs. My database setup is following the
the practice labs designed by Oracle. I'm not using the any GUI,
everything is done by command line.

From the Win2k Pro CMD, I type sqlplus. I modified the
windows registry to prevent my setup database from auto
starting. So in the glogin.sql I'v place the STARTUP PFILE
command to start the setup database. I staying away
from the SQL*Plus application.


Quote:
Originally posted by alligatorsql.com
Hello,

what is SHOW SGA ???

I think, this is not a valid command

Greetings
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On