Re: no output from SQL*Plus, it just hangs

From: Macrosoft <tansel_at_openix.com>
Date: 1998/03/11
Message-ID: <35071B34.3301@openix.com>#1/1

Paul Osborn wrote:
>
> Additionally, determine whether a login.sql script is attempting to run a SQL
> statement against a table for which the user does not have access.
>
> Regards,
> Paul

Paul,

I have to clarify one thing, I guess. I am having this problem not during login but when I try to execute a query. Previously I was getting some error messages complaining about the product_profile tables during login. I ran the pupbld.sql (or something like that) script that creates the product tables. But still it didn't fix the hanging problem. Another thing noticed is that after the login, right before the SQL> prompt, it says 'Input truncated to 15 characters';

SQL*Plus: Release 3.3.2.0.2 - Production on Wed Mar 11 18:14:23 1998

Connected to:
Oracle7 Workgroup Server Release 7.3.2.2.1 - Production Release PL/SQL Release 2.3.2.2.0 - Production

Input truncated to 15 characters    <-------------------

SQL> And No, I don't have the PAUSE parameter set to ON.

Thanks..

Tansel

>
> Billy Verreynne wrote:
>
> > Tansel Ozkan wrote in message <34F4A87B.3153_at_openix.com>...
> > >I am having a problem with SQLPlus. I am not able to get any output from
> > >SQLPlus whatever command I submit. It displays the 'Query is executing'
> > >message and just hangs. The same problem is occurring with all the
> > >instances I connect to. The interesting thing is that when I submit the
> > >same queries from SQL Worksheet, there is no problem.
> >
> > Mebbe you have SET PAUSE ON in SQL*Plus? Try pressing enter when the query
> > seems to hang.
> >
> > regards,
> > Billy
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Paul Osborn
Received on Wed Mar 11 1998 - 00:00:00 CST