Hi ,
I am basically sap bo developer, my superior assigned me task based on pl/sql.
past one week i am struggling to solve the issue.If my question is silly, sorry for that.
My task is to load the data dynamically.
1.Load the data from source table to target table.
e.g,
create table load_test(
SOURCE_TABLE VARCHAR2(32),
TARGET_TABLE VARCHAR2(32),
SOURCE_COL VARCHAR2(32),
TARGET_COL VARCHAR2(32),
)
1. START WITH COPY THE ABOVE FILE TO TARGET PROCEDURE FILE
2. READ THE SOURCE TABLE NAME FROM CONFIG TABLE
3. GENERATE A DYNAMIC CURSOR STATEMENT WITH THIS SOURCE TABLE NAME
4. WRITE THIS DYNAMIC STATEMENT TO TARGET PROCEDURE FILE 5. GENERATE DYNAMIC FETCH STATEMENT AND WRITE TARGET PROCEDURE FILE 6. READ SOURCE COLUMNS AND CORRESPONDING TARGET COLUMNS
7. GENERATE A DYNAMIC INSERT STATEMENT USING THIS SOURCE COLUMNS AND TARGET COLUMNS. EG. INSERT INTO "TARGET TABLE NAME (TARGET COL1,
COL2...) VALUES (C. SOURCE COL1, COL10, COL11, ...)
8. WRITE THIS STATEMENT TO TARGET PROCEDURE FILE 9. WRITE "END LOOP, END; /' TO TARGET PROCEDURE FILE 10. CLOSE THE PROGRAM.

Kindly help me to fix this issue.