PL/SQL Block

From: Mike <learning_dba_at_yahoo.com>
Date: 10 Apr 2003 13:50:02 -0700
Message-ID: <d0966715.0304101250.6d92eb7c_at_posting.google.com>


Hi I have a table t1(c1 number,c2 number,c3 varchar2(10),c4 number,c5 varchar2(10))
I have a procedure bmf_insert.
I need to write a block wherein I select the values from table t1 and then call the procedure bmf_insert.
The procedure bmf_insert inserts values into a table bmf the structure which is below.One of the values tracking_id in the table bmf is the max value from another table seq_num.
How can I write a pl/sql block such that I select the values from table t1,the max tracking_id from table seq_num and execute the procedure bmf_insert?

ACCOUNT_NO                                NOT NULL NUMBER(10)
 BILL_REF_NO                               NOT NULL NUMBER(10)
 BILL_REF_RESETS                           NOT NULL NUMBER(3)
 ORIG_BILL_REF_NO                                   NUMBER(10)
 ORIG_BILL_REF_RESETS                               NUMBER(3)
 CR_NOTE_BILL_REF_NO                                NUMBER(10)
 CR_NOTE_BILL_REF_RESETS                            NUMBER(3)
 BMF_TRANS_TYPE                            NOT NULL NUMBER(10)
 TRANS_DATE                                NOT NULL DATE
 POST_DATE                                 NOT NULL DATE
 CURRENCY_CODE                             NOT NULL NUMBER(6)
 TRANS_AMOUNT                              NOT NULL NUMBER(18)
 GL_AMOUNT                                          NUMBER(18)
 TRACKING_ID                               NOT NULL NUMBER(10)
 TRACKING_ID_SERV                          NOT NULL NUMBER(3)
 ORIG_TRACKING_ID                                   NUMBER(10)
 ORIG_TRACKING_ID_SERV                              NUMBER(3)
 TRANS_SOURCE                                       NUMBER(3)
 SOURCE_TYPE                               NOT NULL NUMBER(3)
 SOURCE_ID                                 NOT NULL NUMBER(10)
 SOURCE_ID_SERV                            NOT NULL NUMBER(3)
 BATCH_ID                                           VARCHAR2(15)
 BATCH_ID_SERV                                      NUMBER(3)
 TRANS_SUBMITTER                           NOT NULL CHAR(30)
 CHG_DATE                                  NOT NULL DATE
 NO_BILL                                   NOT NULL NUMBER(1)
 ACTION_CODE                               NOT NULL CHAR(5)
 CCARD_ID                                           NUMBER(10)
 CCARD_ID_SERV                                      NUMBER(3)
 MICR_BANK_ID                                       VARCHAR2(20)
 MICR_DDA_NUM                                       VARCHAR2(20)
 MICR_CHECK_NUM                                     VARCHAR2(15)
 ARCH_FLAG                                 NOT NULL NUMBER(1)
 MANUAL_CCAUTH_CODE                                 VARCHAR2(18)
 MANUAL_CCAUTH_DATE                                 VARCHAR2(4)
 DISTRIBUTED_AMOUNT                                 NUMBER(18)
 DISTRIBUTED_GL_AMOUNT                              NUMBER(18)
 FILE_ID                                            NUMBER(10)
 RESPONSE_CODE                                      CHAR(12)
 BILL_ORDER_NUMBER                                  VARCHAR2(25)
 EXTERNAL_AMOUNT                           NOT NULL NUMBER(18)
 EXTERNAL_CURRENCY                         NOT NULL NUMBER(6)
 OPEN_ITEM_ID                                       NUMBER(10)
 DISCOUNT_ID                               NOT NULL NUMBER(10)
 TAX_TYPE_CODE                             NOT NULL NUMBER(10)
 ANNOTATION                                         VARCHAR2(255)



TABLE_NAME                                NOT NULL CHAR(30)
 SEQ_NUM                                   NOT NULL NUMBER(10)
Received on Thu Apr 10 2003 - 22:50:02 CEST

Original text of this message