SQL+ and long named files : WARNING !

From: Patrick Marcouly <patrick.marcouly_at_gsi.fr>
Date: Mon, 20 Jul 1998 20:57:53 +0200
Message-ID: <6p07kc$koe$1@pegase.production.axime.fr>

Hello all.

I'm a newbie and I've got a bad surprise today : SQLplus (my version is 3.3.2.0.2) can't manage files with names longger than 8 letters.

Whatever the file name is, if it's longger than 8 lettres, SQLplus truncate the name to 8 positions.

Exemple : if I write @c:\makebase2.SQL; , SQLplus will not say me something like "invalid file name", but it will do as I writed @c:\makebase.sql; forgetting my 9th letter.

Bad luck : I had two files in my directory (MAKEBASE.SQL and MAKEBASE2.SQL) and SQLplus executed the wrong one, making big trouble in my database.

So warning other newbies, never use long file names with SQLplus (in that version)!

What about SQLplus in version 8 ? Received on Mon Jul 20 1998 - 13:57:53 CDT