Hi,
how to create a procedure in oracle forms to create a global temporary table and insert the non database items data.
thanks.
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
You can create the global temporary table separately and then you can insert the data from Oracle Forms. There is no need to create the global temp table using the procedure.
SamSam
CREATE GLOBAL TEMPORARY TABLE temp_table (
col1 NUMBER,
col2 VARCHAR2(100)
)
ON COMMIT DELETE ROWS;
Or
CREATE GLOBAL TEMPORARY TABLE temp_table (
col1 NUMBER,
col2 VARCHAR2(100)
)
ON COMMIT PRESERVE ROWS;