how can i resolve oracle error 00103
I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT= BUSINESS_UNIT1; C C1%ROWTYPE; BEGIN FOR C IN C1 LOOP BEGIN INSERT INTO SYSADM.voucher_tmp values (C.BUSINESS_UNIT,C.VOUCHER_ID,C.INVOICE_ID); COMMIT; END [...]

Answer Question   |  September 22, 2008  4:36 PM
ORA-00103, Oracle 9i, Oracle error messages, PL/SQL