Re: A PL/SQL problem...

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: 2000/05/24
Message-ID: <16RW4.29725$HG1.615433@nnrp1.uunet.ca>#1/1

What about:

file c:\temp\test.sql

DECLARE -- not define

   vv NUMBER := 5;

 BEGIN
  vv := 6;
   DBMS_OUTPUT.PUT_LINE ('Value of vv: ' || TO_CHAR(vv));  END;
 /

SVRMGR> connect scott/tiger
SVRMGR> SET SERVEROUTPUT ON
SVRMGR> @c:\temp\test

Statement processed.
Value of vv: 6

HTH Witold

---

Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com
http://www.novalistech.com

"cfs.public" <cfs.public_at_wanadoo.fr> wrote in message news:8gc501$dct$1_at_wanadoo.fr...
>
> 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 Wed May 24 2000 - 00:00:00 CDT