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 76790 - Make 'Exec' and 'Execute' working for Oracle DB
Summary: Make 'Exec' and 'Execute' working for Oracle DB
Status: RESOLVED DUPLICATE of bug 165125
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: Sun Solaris
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-05-24 10:38 UTC by Max Sauer
Modified: 2009-10-23 08:52 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 Max Sauer 2006-05-24 10:38:35 UTC 
'Exec' and 'Execute' do not work as expected when trying to execute a procedure
over Oracle 10g. On the contrary, 'Call' works ok.

Ie:
exec add_prod(242355, 'neco2333');
produces:
--
Error code 900, SQL state 42000: ORA-00900: invalid SQL statement
Line 1, column 1

Execution finished after 0 s, 1 error(s) occured.
--

but:
call add_prod(242355, 'neco2333');
executes succesfully.

----------
NetBeans 5.5 Dev (Build 200605220200)
SunOS version 5.10 running on sparc
Java HotSpot(TM) Client VM 1.6.0-beta2-b84
Oracle 10g
Comment 1 Jiri Rechtacek 2009-10-16 14:05:52 UTC 
Reassigned to new owner.
Comment 2 Jiri Rechtacek 2009-10-23 08:52:16 UTC 

*** This issue has been marked as a duplicate of 165125 ***