Consultor Eletrônico



Kbase P91555: Is there a way for Progress Oracle data server to convert Progress "date" data type to Oracle "numbe
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   9/3/2004
Status: Unverified

GOAL:

Is there a way for Progress Oracle data server to convert Progress "date" data type to Oracle "number" data type?

GOAL:

I have oracle database created , all the "date" data are stored as "number" field, my progress code still uses "date" data type, is there a way for oracle data server to convert progress date to Oracle number?

FACT(s) (Environment):

Oracle DataServer

FIX:

Oracle data server does not map Progress "date" data type to Oracle "number" data type. An oracle view can be created to accomplish the mapping inside Oracle itself.