Re: SPOOL PROBLEM IN SQL*PLUS

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 27 Aug 1998 20:33:19 +0200
Message-ID: <6s48rh$orn$1_at_pascal.a2000.nl>


>spool ../../.../error/pri_gtd5.err

I guess the dots are not really there? Otherwise, there is one dot too many in the third part. Also, when using the dots make sure that you are starting SQL*Plus from the right directory. Like

    my_home/my_app/sql> sqlplus scott/tiger _at_my_script     ( ../error yields the directory my_home/my_app/error)

is different than

    my_home/my_app> sqlplus scott/tiger _at_sql/my_script     ( ../error yields the directory my_home/error)

Otherwise: could it just be lack of write permissions to the specified directory, or the exisitng file? Or: subdirectory error does not exist yet?

Arjan. Received on Thu Aug 27 1998 - 20:33:19 CEST

Original text of this message