Malformed Error Defining Cursor link to SQL Server via SQL Developer Package


    Public database link is under the main connection ahisqa and is defined as:


    username: readit

    Host: dg4odbc


    Oracle SQL Developer v

    Oracle 11g

    MS SQL Server 2012


    The package is under Other Users / ahisqa.

    CURSOR c_RetrieveLkupCoverage


           SELECT *      

       FROM Construct.dbo.LkupCoverage@CONSTR_LINK

              WHERE LkupCompanyKey in (6,301)



    When I save, I receive the error:

    Error(229,11): PLS-00341: declaration of cursor 'C_RETRIEVELKUPCOVERAGE' is incomplete or malformed