Timeline for Table doesn't exists issue with Oracle stored procedure
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jan 13, 2020 at 12:14 | history | suggested | Boneist | CC BY-SA 4.0 |
SQL is a language. SQL Server is an RDBMS platform. Please don't confuse the two.
|
| Jan 13, 2020 at 10:33 | answer | added | Muthukrishnan Senthilkumaran | timeline score: -1 | |
| Jan 13, 2020 at 10:32 | answer | added | Boneist | timeline score: 2 | |
| Jan 13, 2020 at 10:26 | review | Suggested edits | |||
| S Jan 13, 2020 at 12:14 | |||||
| Jan 13, 2020 at 9:15 | comment | added | user168186 | Are you dropping test_table_1 too? If any referencing objects in procedure does not exist or dropped at compile time or run time the object becomes invalid.Check if test_table_1 exists then compile procedure.How are you handling exceptions? | |
| Jan 13, 2020 at 8:39 | answer | added | eagle275 | timeline score: 1 | |
| Jan 13, 2020 at 8:36 | comment | added | Akina |
PLS-00905 object SYSTEM.TEST_PROC is invalid Oracle tells that the object named TEST_PROC in SYSTEM namespace is invalid (I think it is invalid for to execute it as a procedure, but I could be wrong in that point), and says nothing about any table.
|
|
| Jan 13, 2020 at 8:34 | comment | added | Akina |
As you can see that TEST_TABLE_2 is getting created on the fly in this procedure and will be getting dropped in next subsequent procedure. ??? I see that you use TEST_TABLE_2 as existing static table. The table which is getting created on the fly in this procedure and will be getting dropped is CTE table CTE_TEST_TABLE_DATE.
|
|
| Jan 13, 2020 at 8:31 | answer | added | Balazs Papp | timeline score: 4 | |
| Jan 13, 2020 at 8:30 | history | edited | Akina | CC BY-SA 4.0 |
Code formatting
|
| Jan 13, 2020 at 8:26 | history | asked | vikrant rana | CC BY-SA 4.0 |