Hi, 'im new in Datagrip and PLSQL programming in general (and programming in general too)
I'm writing some code in plsql for an apex application and i get some error in my code even if it runs ok.
The problem is that some columns are not resolved for the IDE, take this example:
Here DataGrip could not find p.line_number and p.COL006 and COL008. p are wwv_flow_t_parser_row objects that has not been declared in the Declaration section of the procedure.
So i had declared it in the declare section of the procedure (the outermost one in the procedure realm) but the error keep showing.
If i declare the p object it in the declaration section after the loop statement:
errors are gone and the ide is happy again.
So, i'm asking as im still learning:
1) Is correct to declare the p object to get the errors away (the procedure work the same way)
2) Is correct to have to declare them inside the loop and not in the main delcaration section of the procedure to get the errors away?