connect oracle with sql server with a query

asma gh 21 Reputation points
2022-02-24T10:23:56.607+00:00

hello , i'm trying to connect an oracle database with an sql server base withan oledb source by creation an select querry but i got this error msg

ora-00936 : missing expression

177493-inkederror-li.jpg

any idea please

thank you

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 36,511 Reputation points
    2022-02-25T06:12:34.11+00:00

    Hi @asma gh ,

    ORA-00936 missing expression Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.

    Action: Check the statement syntax and specify the missing component.

    The ORA-00936 happens most frequently:

    1 - When you forget list of the column names in your SELECT statement.
    2 - When you omit the FROM clause of the SQL statement.

    ora-00936-missing-expression

    Please check your query again to make sure the column and table name is correct.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.