i face this error when trying to compile this pl/sql block Error: PLS-00103: Encountered the symbol "THEN" when expecting one of the following: := . ( % ; declare CURSOR abc IS select * from all_Objects; begin for rec in abc loop ...
Question
Oraask Latest Questions
Question
please i want to read excel (.xlsx) from PLSQL ? is that possible or not ?
Question
I have a cursor declared inside procedure into package and I want to use this cursor into another procedure or function inside the same package is that possible or not ?
Question
I'd like to create pl/sql array variable to hold an ordered collection of data thanks.