![]() ![]() ![]() CREATE GLOBAL TEMPORARY TABLE tt_RptRCRsn ![]() I dont want to make major modifications to the stored procedure as this is the requirement to keep the migrated code (oracle procedures) as similar as possible to the existing code (Sybase procedures)Ĭan someone please suggest a solution on how do I achieve this?īeware that the two commands will be run in the current schema, which is usually the schema that you logged in to. I tried giving grant all to this stored procedure but still its not compiling, The migrated proceure is not able to find the global temporary table 'tt_RptRCRsn'. The migrated stored procedure compiles with an error - 'Table or view does not exist' even though global temporary table was created. WHERE COMMENTS.BatchNo = tt_RptRCRsn.BatchNoĪND COMMENTS.ComNo = ( SELECT MAX(COMMENTS.ComNo) SET Comment_ = ( SELECT COMMENTS.Comment_ ![]() The tool migrates alomost 70%-80% of the stored procedures except a few cases where there is a temporary table created and used inside a stored procedures.Įxisting sybase stored procedure: CREATE GLOBAL TEMPORARY TABLE tt_RptRCRsn I am migrating a few stored procedures from Sybase to Oracle using Oracle Developer tool. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |