Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

while migration to oracle SQL Error: ORA-00906: missing left parenthesis

User2979Dec 20 2007 — edited Jan 10 2008
hi , i'm working on migration from sql server 2005 to oracle 10g. when i'm tryinng to run gernerated scripts in views it shows error message as SQL Error: ORA-00906: missing left parenthesis

the code is
CREATE OR REPLACE VIEW V_TRAC_PARAM
AS
SELECT CAST(TRAC_PARAM_NB_GROUPE AS VARCHAR2) || '_' || CAST(TRAC_PARAM_NB_SOCIETE AS VARCHAR2) || '_' || CAST(TRAC_PARAM_NB_ETAB AS VARCHAR2) TRAC_PARAM_VC_GSE,
TRAC_PARAM_NB_GROUPE,
TRAC_PARAM_NB_SOCIETE,
TRAC_PARAM_NB_ETAB,
TRAC_PARAM_NB_PDOP_MAX
FROM T_TRAC_PARAM ;
please help me in solving this issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2008
Added on Dec 20 2007
#database-and-application-migrations
2 comments
2,898 views