Re: Will PL/SQL work?

From: knez <knez_at_ix.netcom.com>
Date: Sat, 24 Oct 1998 19:58:26 -0400
Message-ID: <70tpig$ala@dfw-ixnews5.ix.netcom.com>

I ran the script that you provided and received this as an error:

S1000: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-06550: line 1 column 31:
PLS-00103: Encountered the symbol "INTEGER" when expecting one of the following:

:=.(@%; not null range renames default.

I tried both the ODBC and the Oracle Driver, neither worked.

I also ran the script in SQL*PLUS and received this as an error:

Connected to:
Oracle7 Server Release 7.3.3.5.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.3.5.0 - Production

SQL> declare
  2 testInt integer;
  3 begin
  4 select sysdate from dual;
  5 end;
  6 /
    select sysdate from dual;
    *
ERROR at line 4:

ORA-06550: line 4, column 5:
PLS-00428: an INTO clause is expected in this SELECT statement
ORA-06550: line 4, column 5:

PL/SQL: SQL Statement ignored

Michael Krolewski wrote in message <36324197.54BEF444_at_u.washington.edu>...
>If you can run SQL you can run PL/SQL;
>
>You can type a simple but not useful.
>
>declare
> testInt integer;
>begin
> select sysdate from dual;
>end;
>
>Mike Krolewski
>
>knez wrote:
>
>> I'm running Oracle 7. A 3rd party is housing and managing our data (they
>> give passwords and rights etc). The data can be accessed through a T1 or
a
>> dial-up via an ISP. I use a dial-up do to cost. I use a Platinum product
>> (Forest & Trees) as my GUI front-end. F&T has a report writer and handles
my
>> SQL commands. I also can create decent application for end users.
>>
>> I write only SQL queries. I would like to what the benefits of SQL*PLUS
and
>> PL/SQL.
>>
>> I would also know how I can find out if I can run PL/SQL. Can someone
give
>> me a small innocuous piece of code that will let me know that I can run
>> PL/SQL.
>
>
>
Received on Sat Oct 24 1998 - 18:58:26 CDT