This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 200799 - Support 'PROMPT' statements in sql scripts for oracle
Summary: Support 'PROMPT' statements in sql scripts for oracle
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 7.0.1
Hardware: All All
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-09 14:40 UTC by tomzi
Modified: 2013-08-01 12:53 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tomzi 2011-08-09 14:40:48 UTC 
When running batch updates containing PROMPT statements like
....
PROMPT altering table JAHRESFONDSERTRAG_LD...
ALTER TABLE JAHRESFONDSERTRAG_LD ADD 
(
   D_ED148A         VARCHAR2(1),
   D_ED212          NUMBER(23,10),
   D_ED212A         VARCHAR2(1),
   E_ED148A         SMALLINT,
   E_ED212          SMALLINT,
   E_ED212A         SMALLINT
);

NB would complein that the PROMPT statement is an invalid SQL statement. However our batch statement usually run in an sql console and not in NB. It would be helpful if NB could interpet these statements when running against a oracle db.



Product Version = NetBeans IDE 7.0.1 (Build 201107282000)
Operating System = Windows 7 version 6.1 running on amd64
Java; VM; Vendor = 1.7.0
Runtime = Java HotSpot(TM) 64-Bit Server VM 21.0-b17
Comment 1 tomzi 2011-08-09 14:44:15 UTC 
Same with eg

SET DEFINE OFF;