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>
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