Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL 3.1 problem

SQL 3.1 problem

From: Steven Hovington <steve.hovington_at_datacore.demon.co.uk>
Date: 1997/10/06
Message-ID: <01bcd270$d84e1fe0$6655989e@stevewin95.datacore.demon.co.uk>#1/1

I have an .sql file, which 41KB in size. It contains details of a complete package that I what to create in an existing Oracle database.
I can run the script and it all works fine. But as soon as I add the following three lines

  IF TASK_NUMBER=21 THEN
     RAISE_APPLICATION_ERROR(-20333,'TASK NUMBER IS 21');   END IF; and try to compile, SQL Plus 3.1 falls over with this message.

PLUS31 caused a general protection fault in module ORA71WIN.DLL at 0005:00000ce8. Registers:

EAX=00000000 CS=362f EIP=00000ce8 EFLGS=00000a02
EBX=0000ffff SS=3057 ESP=0000b3c0 EBP=0000b3c6
ECX=00003f83 DS=2a9f ESI=00000126 FS=0000
EDX=0000ffed ES=2dc7 EDI=000003e0 GS=0147
Bytes at CS:EIP:
f3 a5 13 c9 f3 a4 91 e3 18 0b f6 75 07 8c d8 05 Stack dump:
00000001 b3f8363f 0e0f4e86 2dc702cc 2a9f0012 0001801a a3130000 1c371c37 a091001e 00021c37 03100000 00002ecf 0d7e2ecf 363f2ecf a397b895 028e0e0f

Are there any bugs in Oracle 7.1 which could be causing this problem? I would appreciate any help on the this matter.

Thanks in advance

Steven Hovington
Datacore Ltd. Received on Mon Oct 06 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US