Re: SQL*Plus Worksheet 2.1 (oracle 8i)

try adding a / on the next line.

the last semicolon in your 'create package' statement only ends the statement on the last line. to execute the statement, you would add a / as the next line.

SQL*Plus Worksheet uses the SQL*Plus
executable, and this is normal SQL*Plus
behavior.

HTH "JSI FundRaising R&D Group" <mjames_at_jsifrs.com> wrote in message news:CCWR4.20882$Lx.3572748_at_news-west.usenetserver.com...
> Let's use the example of a create package,
> create or replace package name_pkg is
> type keytable
> is table of number(13,0) index by binary_integer;
> namekey_tbl keytable;
> countum integer := 0;
> end name_pkg;
>
> I open this and execute nothing happens, it highlights the
 whole thing but
> no error, no nothing.... and it isn't in the database.
>
>
> Brian Tkatch wrote in message

 <39180805.1070500_at_news.alt.net>...
> >Just a quick thought. Do you have more than one statement?
 Did you end
> >each one witha semi-colon? I made the mistake once and only
 one
> >statement ran.
> >
> >Brian
> >
> >On Mon, 8 May 2000 09:32:19 -0400, "JSI FundRaising R&D
 Group"
> ><mjames_at_jsifrs.com> wrote:
> >
> >>Problems using SQL*Plus Worksheet
> >>
> >>With Oracle 8.1.6 we loaded the new Enterprise Manager and
 Tools. We have
> >>used Oracle 7.x and Oracle 8.x on an NT Platform for a
 number of years. We
> >>do development work for clients who actually use the
 databases. I have
 been
> >>using the old SQL Worksheet for all Query jobs including
 trigger creation
> >>from txt files. Now we are trying to get familiar with
 Oracle 8i (8.1.6),
 we
> >>have clients wanting to use it. I try to use SQL*Plus
 Worksheet and it
> >>doesn't seem to ever do anything. I open one of the create
 trigger text
> >>files hit execute, it highlights the text but nothing
 happens. I use the
> >>menu option to open and execute a local script same thing...
> >>
> >>I type in select statements, hit execute nothing happens, no
 error, no
> >>results. What am I doing wrong. I can't find any good
 documentation on
 this
> >>tool. Oracle Support pointed me toward Chapter 7 in the
 Enterprise
> >>Managers Admin documentation, but it only has 1-2 paragraphs
 on what the
> >>tool is, no how do you use it stuff.
> >>
> >>
> >>
> >>
> >
>
>
>
>
>
Received on Tue May 09 2000 - 00:00:00 CDT