[news.eclipse.dtp] Re: Error while trying to get UDF, Stored Proc from a

[Brian Fitzpatrick <bfitzpat@xxxxxxxxxx>]

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