CODEWITHSUNDEEP
oracle-databaseoracleforms
Amir
Amir

Reputation: 1979

how to read data blocks and store them in database?

Hi there I have problem in reading a data block in oracle form builder.
I have one data block that some of their fields are come from database but there is 2 (columns)field that i need to read them manually and store them on the database(we have several row!),please help me how I can read each line and insert them on database.
I use oracle form builder ver 6i.

Thanks in advance,

Upvotes: 2

Views: 4674

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132580

You can write code like this in Forms:

GO_BLOCK('myblock');
FIRST_RECORD;
LOOP
  INSERT INTO my_table (col) VALUES (:myblock.item1);
  EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
  NEXT_RECORD;
END LOOP;

Upvotes: 4

Related Questions