| Error while trying to get UDF, Stored Proc from a Oracle database(10g) [message #57485] |
Mon, 27 July 2009 03:35  |
Eclipse User |
|
|
|
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 17:25  |
| Eclipse User |
|
|
|
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 17:25 |
| Eclipse User |
|
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.04349 seconds
Home