Oracle APPS Consultancy: Forward Declarations in PLSQL?
Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376) What all the ,methods I can go for if we are working on a production environment with out any down time. I can go for dbms repair package and restore and recover.
CURSOR: do something that is to be done row by row and not possible with simple query for example, if you have a temporary table to store hierarchy of categories, cursor can be useful to populate it procedures or stored procedures are something th.
PLSQL Block PLSQL code is grouped into structures called blocks A Block from CSE CS 101 at Guru Nanak Institute Of Technology.
In forward declaration, the actual element is not coded, but rather a declaration of it is made before calling it in another program unit. This ensures that Oracle knows the code for the declared program unit is somewhere later present in the code. There are few guidelines for forward declaration as well: 1. A variable or a cursor cannot be forward declared. 2. Only modules like a procedure or.