Please suggest some solution, if possible on the
I have a problem in the procedures and functions which have been migrated from sybase to oracle.
The problem is something like this :-
In some procedures I have some code which inserts some
data into a temporary table which has not got created
because in its creation statement they are accessing a
variable from the same procedure which is in invalid
status bcoz its not getting compiled due to the absence
of the temporary table. Its like a loop/cycle.
Let A be the procedure in which we are accessing
temporary table B. This temporary Table B is not
getting created Bcoz it is accessing a local variable
in procedure A which is in invalid state/not compiled
CREATE GLOBAL TEMPORARY TABLE B
ON COMMIT PRESERVE ROWS AS
RPAD(SP_A.sid_, 64, ' ') id, cusip, order_id, status,
created, settles, ordered, price, principal, order_type, updated_time,
updated, description, accrued, total, ytc, ytm, coupon, maturity, created_time
WHERE 1 = 2 ;
THE ABOVE ONE IF I AM TRYING TO CREATE IT IS GIVING AN ERROR OF INVALIDSTATE/INVALID COLUMN
THIS TEMPORARY TABLE WE ARE ACCESSING INTHE PROCEDURE TO INSERT ROWS.