[tfe]

Hi,

I have some difficulties with the Enhanced Oracle Connector. I’m not able to create metadata from tables, procedures etc. (menu items missing). There is also no option to view or create sequences.

I’m using Eclipse 3.1.1. and MyEclipse 4.0.1 (Pro version), Pro Features are activated in Preferences. All schemas are displayed during connection. I’m connecting to an Oracle 10.1.0.2 Database running on Windows XP by using the Thin Oracle JDBC Driver (version 10.1.0.4).

Any help is appreciated.

Many thanks and best regards,
tfe

[Riyad Kalla]

I’ll ask someone to look intot his, hang in there tfe.

[Brian Fernandes]

tfe,

Could you bring up a context menu on a Table Node and enumerate exactly the menu options you see?
Also, can you do the same for a Procedure or a Function node and enumerate the options?

You should be able to view your Sequences just fine but we do not have an option allowing you to create Sequences currently.

Best,
Brian.

[Bill Lunnon]

Hi Support,

My problem is that attempts to create an Oracle (9.2) stored procedure
(sample below) using the database explorer fails.
Please note that I have “validated” the script in Toad (i.e. the script
compiles correctly in Toad and can be run from the MyEclipse database
explorer when selecting the PROCEDURE Run – right click – option).
Please also note that if as load the stored procedure using Toad, I can
call the stored procedure in a SQL query window via “call removeFeature
(10);”

From the error log (.workspace/.metadata/.log)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:31.875
!MESSAGE Error processing query: ‘begin
call removeFeature(10)’
!STACK 0
java.sql.SQLException: ORA-06550: line 1, column 6:
PLS-00103: Encountered the symbol “” when expecting one of the
following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:31.875
!MESSAGE Error processing query: ‘end’
!STACK 0
java.sql.SQLException: ORA-00900: invalid SQL statement

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:31.875
!MESSAGE Error processing query: ‘/’

!STACK 0
java.sql.SQLException: Invalid SQL type
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:16
2)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:22
7)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:63)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:51.984
!MESSAGE Error processing query: ‘BEGIN
select featureId into c_featureId
from newspaper
where featureId = p_featureId’
!STACK 0
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol “” when expecting one of the
following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
The symbol “begin was inserted before “” to continue.
ORA-06550: line 2, column 36:
PLS-00103: Encountered the symbol “” when expecting one of the
following:

. ( , % from

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:51.984
!MESSAGE Error processing query: ‘if (p_featureId is not null)
then
delete newspaper
where featureId = p_featureId’
!STACK 0
java.sql.SQLException: ORA-00900: invalid SQL statement

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:51.984
!MESSAGE Error processing query: ‘end if’
!STACK 0
java.sql.SQLException: ORA-00900: invalid SQL statement

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-11 17:34:52.000
!MESSAGE Error processing query: ‘END’
!STACK 0
java.sql.SQLException: ORA-00900: invalid SQL statement

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:474)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1027)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1515)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlE
xecProgress.java:156)
at
com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgre
ss.java:117)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalCon
text.java:113)

My environment:
Windows XP
MyEclipse Version 4.0.0 GA Build Id: 20050829-4.0.0.GA
Eclipse SDK Version: 3.1.0 Build id: I20050923-1000
Java j2sdk1.4.2_09
Database driver weblogic (ojdbc14.jar) – oracle.jdbc.driver.OracleDriver

[tfe]

@Support-Brian wrote:

tfe,

Could you bring up a context menu on a Table Node and enumerate exactly the menu options you see?
Also, can you do the same for a Procedure or a Function node and enumerate the options?

You should be able to view your Sequences just fine but we do not have an option allowing you to create Sequences currently.

Best,
Brian.

Brian,

the context menu on the TABLE Node only contains an option for refreshing the view, the context menu on an individual table consists of the following menu options:

1. Generate Select Statement
2. Edit Data
3. Refresh Table
4. Generate Table Script
5. Copy Object Name
6. Create Hibernate Mapping

The context menu on the PROCEDURE Node is showing the following menu options:

1. Copy Object Name
2. Refresh
3. New Stored Procedure

The context menu on an individual procedure is showing the following menu options:

1. Copy Object Name
2. Run
3. Open

The context menu on the FUNCTION Node is showing the following menu options:

1. Copy Object Name
2. Refresh
3. New Function

The context menu on an individual function is showing the following menu options:

1. Copy Object Name
2. Run
3. Open

Hope that helps. Please give me a short notice if you need further information.

Best regards,
tfe

[tfe]

Brian,

any idea what is going wrong?

Regards,
tfe

[PAETEC Communications]

I have the exact same set up (Eclipse 3.1, MyEclipse 4.0, etc) and I cannot execute CREATE OR REPLACE for procedures OR packages. The following SQL put into a SQL editor gives me an “ORA-00900 Invalid SQL statement” error.

CREATE OR REPLACE PROCEDURE TEST_PROCEDURE( in_param IN VARCHAR2 )
AS
BEGIN
DELETE MYSCHEMA.TABLE_A a WHERE a.ID = in_param;
COMMIT;
END;
/

If I remove the first two semi-colons (at the end of in_param and COMMIT), it works. But then looking in TOAD, its not valid and doesn’t compile. But if I open a valid procedure FROM THE DATABASE in MyEclipse, I can successfully run it. When it fails, the error in the logs is:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-11-08 15:50:10.088
!MESSAGE Error processing query: ‘END’
!STACK 0
java.sql.SQLException: ORA-00900: invalid SQL statement

Apparently, myEclipse is having trouble with multiple semi-colons, or better said, multiple nested statements.

I’d like to Right-Click on a .sql file in my eclipse project, select “Open with MyEclipse SQL Editor”, select a DB connection and click RUN and have it install.

[PAETEC Communications]

My problem reposted to
https://www.genuitec.com/forums/topic/sqlexception-running-create-or-replace-statements/

[Author]

Posts