Declare
Inst_name varchar2 (100);
Cursor Mycur is
SELECT * from Tran_forward t where t.instrument_type_id= ' 3010 ';
Query_row Tran_forward%rowtype;
Begin
Open mycur; --Open cursor
Loop
Fetch mycur into Query_row; --Place the record indicated by the cursor in the variable
Select T.instrument_type_name to Inst_name from Bas_instrument_type t where T.instrument_type_id=query_ row.instrument_type_id;
Exit when (Mycur%notfound); --Exits the loop when the cursor does not point to a row
Dbms_output.put_line (' seq has: ' | | query_row.forward_id | | ' Records ');
Execute immediate
' INSERT INTO tran_sumary_infomation
(ID,
TRANSACTION_ID,
Tran_type_name,
Tran_link_url,
Tran_entity,
TRAN_TYPE_ID)
VALUES (: 1,:2,:3,:4,:5,:6) '
Using hibernate_sequence.nextval,query_row.forward_id, Inst_name, '/tran/tranforwardedit.aspx ', ' TranForward ', query_row.instrument_type_id;
Commit
End Loop;
Close mycur;
End
Oracle Plsql Parameters