From: rz34@hp850.rz.uni-karlsruhe.de (Schillinger)
Newsgroups: comp.databases.oracle
Subject: Break On problem in SQL*Plus
Date: 5 May 1993 07:09:35 GMT
Organization: University of Karlsruhe, Germany
Lines: 21
Distribution: world
Message-ID: <1s7p7f$5i3@nz12.rz.uni-karlsruhe.de>
Reply-To: rz34@rz.uni-karlsruhe.de
NNTP-Posting-Host: hp850.rz.uni-karlsruhe.de
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Keywords: Break on, skip


Background: Oracle v. 6.0.34.2.1
	    SQL*Plus v. 3.0.11.1.1
	    OS: HP/UX 9000 Series 800

Hi!  I'm trying to do a BREAK ON key_field SKIP 1; in a SQL script.
The funny thing is that is works just fine on the first page and then
stops skipping!  It keeps breaking, but won't skip any more (no matter
if I set it to SKIP 1 or SKIP 5 or whatever).

I tried setting the pagesize to a huge number and then it skips for the
whole report. But when I want to print, I'll need to set it back to
something sensible.

Has anyone experienced this before or does anyone know what I could
be doing wrong?

Thanks in advance!

Karen Schillinger
Schillinger@rz.uni-karlsruhe.de
or rz34@rz.uni-karlsruhe.de