Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Error while trying to get UDF, Stored Proc from a Oracle database(10g)
Error while trying to get UDF, Stored Proc from a Oracle database(10g) [message #57485] Mon, 27 July 2009 07:35 Go to next message
YJ Yoon is currently offline YJ Yoon
Messages: 2
Registered: July 2009
Junior Member
When I double click UDF, Stored Proc on DSE, SQL scrap book shows wrong
informations like below

--------------------------------------
CREATE FUNCTION FC_CONS_INFO (
IN V_OWNER VARCHAR2(0),
IN V_TNAME VARCHAR2(0),
IN V_COL VARCHAR2(0))
RETURNS
NOT DETERMINISTIC
NO_SQL
CALLED ON NULL INPUT
--------------------------------------

Have I got a DTP setting problem?


here is my environment.
------------------------------------------------------
DTP : 1.7.0
eclipse : 3.4.2
ORACLE : 10g Enterprise Edition Release 10.2.0.1.0
Re: Error while trying to get UDF, Stored Proc from a Oracle database(10g) [message #258452 is a reply to message #57485] Mon, 27 July 2009 21:25 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
YJ Yoon wrote:
> When I double click UDF, Stored Proc on DSE, SQL scrap book shows wrong
> informations like below
>
> --------------------------------------
> CREATE FUNCTION FC_CONS_INFO (
> IN V_OWNER VARCHAR2(0),
> IN V_TNAME VARCHAR2(0),
> IN V_COL VARCHAR2(0))
> RETURNS NOT DETERMINISTIC
> NO_SQL
> CALLED ON NULL INPUT
> --------------------------------------
> Have I got a DTP setting problem?
>
>
> here is my environment.
> ------------------------------------------------------
> DTP : 1.7.0
> eclipse : 3.4.2
> ORACLE : 10g Enterprise Edition Release 10.2.0.1.0
>

Hi...

The DDL generator must be extended for each different database type. And
in the Oracle case, I'm betting the Oracle enablement project hasn't
been customized to create Oracle-specific DDL.

You might see if the Oracle enablement download is available from the
Oracle site (it's moved, so I can't tell you exactly where it is now) -
it was customized by Oracle themselves, so it's probably more up to date
with DDL generation.

--Fitz
Re: Error while trying to get UDF, Stored Proc from a Oracle database(10g) [message #596154 is a reply to message #57485] Mon, 27 July 2009 21:25 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
YJ Yoon wrote:
> When I double click UDF, Stored Proc on DSE, SQL scrap book shows wrong
> informations like below
>
> --------------------------------------
> CREATE FUNCTION FC_CONS_INFO (
> IN V_OWNER VARCHAR2(0),
> IN V_TNAME VARCHAR2(0),
> IN V_COL VARCHAR2(0))
> RETURNS NOT DETERMINISTIC
> NO_SQL
> CALLED ON NULL INPUT
> --------------------------------------
> Have I got a DTP setting problem?
>
>
> here is my environment.
> ------------------------------------------------------
> DTP : 1.7.0
> eclipse : 3.4.2
> ORACLE : 10g Enterprise Edition Release 10.2.0.1.0
>

Hi...

The DDL generator must be extended for each different database type. And
in the Oracle case, I'm betting the Oracle enablement project hasn't
been customized to create Oracle-specific DDL.

You might see if the Oracle enablement download is available from the
Oracle site (it's moved, so I can't tell you exactly where it is now) -
it was customized by Oracle themselves, so it's probably more up to date
with DDL generation.

--Fitz
Previous Topic:Error while trying to get tables from a MySQL database
Next Topic:Access Web Services using DTP
Goto Forum:
  


Current Time: Fri Oct 24 11:29:07 GMT 2014

Powered by FUDForum. Page generated in 0.01967 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software