A PL/SQL problem...

I am a french developper and I am creating application arround VB and Oracle 7.3.4 for Windows NT. Beginner with Oracle administration, could anyone assist me ?

I am creating a PL/SQL script that use a variable created with a define statement and I need to modify its value within a DECLARE / BEGIN / END; statement as follow...

• Script : TOTO.SQL

define vv = 5;

BEGIN
-- The following statement is producing an error...
 vv := 6;
END;
/
PROMPT 'VV = ' || &vv;

How can I change the value of vv inside this statement ?

Otherwise, I need to check the value of vv, so I use an IF / THEN / ELSE / END IF; statement.

Is there any way to use this statement outside an BEGIN / END; statement in a PL/SQL script ?

I have another problem (or maybe not for someone probably more experienced than me) :
I have noticed that the UTL_FILE package doesn't run properly with network drive under Windows NT 4 and Oracle 7.3.4. While I am using this package with a local hard disk drive letter on the NT server everything went OK, but when I use the same thing (always on the server) with a network drive that points to the server itself an exception arise. In my initsid.ora I have checked that the "UTL_FILE_DIR = *", and the instance has properly been restarted too. Does anyone experience the same thing ?

I am grateful to anyone for helping me to solve my problem.

Claude Santero. Received on Tue May 23 2000 - 00:00:00 CDT