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

Summary:	Make 'Exec' and 'Execute' working for Oracle DB
Product:	db	Reporter:	Max Sauer <msauer>
Component:	Code	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	blocker
Priority:	P3
Version:	5.x
Hardware:	Sun
OS:	Solaris
Issue Type:	ENHANCEMENT	Exception Reporter:

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 ***