I want to create a Global temporary table in a program after that I have to Insert records from input file. After insert the sql code is displaying as zero. If tyr to fetch records from the same table in the very next step it fetching very first record n number of times
please let me what need to done to insert the records in to temp table.
There can be 2 chances to get the result as you said.
1) While inserting - Read file, move all the fields to host variables every time after read and then insert into Global Temporay Table.
Here If you miss to move fields after first record then every time first record's values will be inserted into Temporary Table.
This may lead to get the result as you said.
2) Cursor steps: Cursor Open, Fetch, Close may be in loop.