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 137036 - Error code 1008, SQL state 72000: ORA-01008: not all variables bound
Summary: Error code 1008, SQL state 72000: ORA-01008: not all variables bound
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P1 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-11 17:59 UTC by jjraphael
Modified: 2008-07-02 19:34 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 jjraphael 2008-06-11 17:59:34 UTC 
When I try running this SQL statement in oracle 10g:

SELECT ALL SCOTT.CODEUTILISATEURS.CODE_UTIL, SCOTT.UTILISATEURS.NOM_UTIL, SCOTT.UTILISATEURS.PRENOM_UTIL, 
SCOTT.UTILISATEURS.MOT_DE_PASSE_UTIL, SCOTT.UTILISATEURS.CAPACITE_UTIL, SCOTT.UTILISATEURS.STATUT_UTIL, 
SCOTT.UTILISATEURS.UTIL_CREATION, SCOTT.UTILISATEURS.DATE_CREATION, SCOTT.UTILISATEURS.UTIL_MODIFICATION, 
SCOTT.UTILISATEURS.DATE_MODIFICATION  FROM SCOTT.CODEUTILISATEURS          INNER JOIN SCOTT.UTILISATEURS ON 
SCOTT.UTILISATEURS.CODE_UTIL = SCOTT.CODEUTILISATEURS.CODE_UTIL WHERE SCOTT.CODEUTILISATEURS.CODE_UTIL = ?

I got this error

Error code 1008, SQL state 72000: ORA-01008: not all variables bound

Please help me
raphy50@yahoo.fr
Comment 1 David Vancouvering 2008-06-11 18:18:09 UTC 
A couple of questions:

- Where are you running this statement: in the NetBeans SQL Editor or elsewhere?  
- If you run this statement using a JDBC program or a tool outside of NetBeans, do you get the same error?
- It looks like you have a parameterized/prepared statement, ("WHERE SCOTT.COEDUTILISATEURS.CODE_UTIL = ?") but you
don't describe how you bind the '?' to a value.  I think that's why Oracle is complaining.
Comment 2 David Vancouvering 2008-06-17 18:44:28 UTC 
Hello, jjraphael.  I'm thikning of closing this issue as it looks like it is a problem with the SQL, not with NetBeans.
 Please response or I'll close in 24 hours.

Thanks!
Comment 3 David Vancouvering 2008-07-02 19:34:57 UTC 
Closing, as user did not provide information needed; I suspect it's a SQL problem and not a NetBeans problem.