asked on

SQL*Loader for Insert.

How can I build do an SQL* Loader to do an insert in the TBRECEIPTS table.

RC_PAYMNB number(10) RC_CASHNB Number(8) RC_DATE Varchar2(19)
---------- ---------- -------------------
42884297 888888 10-10-2004

RC_DATA Vachar2(2500)
-------
T S T T

IND.SQUARE/EDWARD ST

VAT REG# 100476

Bill Payment 2004/07/1 1.00

Account: 91013698-0000

Chantal Rigaud

A/c Balance: 2,534.33

TOTAL 1.00

TENDERED

Cash 1.00

TOTAL TENDERED 1.00

CHANGE 0.00

Payment No: 42884297 Cashier: 888888

18-Oct-2004 09:12

IF YOU NEED TO KNOW

HOW MUCH YOU OWE !

CALL 800-BILL (2455)

pratikroy

Is your datafile a fixed length/delimited file ?

mathieu_cupryk

ASKER

I do not have a data file. I just did a select. I cannot do an insert with RC_DATA field because of <CR> or the square boxes

mathieu_cupryk

ASKER

SP2-0734: unknown command beginning "IND.SQUAR..." - rest of line ignored.
SP2-0734: unknown command beginning "VAT REG# ..." - rest of line ignored.
SP2-0734: unknown command beginning "Bill Payme..." - rest of line ignored.
SP2-0734: unknown command beginning "Account: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "Chantal Ri..." - rest of line ignored.
1* insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004', T S T T /c Balance: 2,534.33
SP2-0734: unknown command beginning "TOTAL ..." - rest of line ignored.
SP2-0042: unknown command "TENDERED" - rest of line ignored.
SP2-0734: unknown command beginning "Cash ..." - rest of line ignored.
SP2-0734: unknown command beginning "TOTAL TEND..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
1* insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004', T S T T /c Balance: 2,53433
SP2-0734: unknown command beginning "Payment No..." - rest of line ignored.
SP2-0734: unknown command beginning "18-Oct-200..." - rest of line ignored.
SP2-0734: unknown command beginning "IF YOU NE..." - rest of line ignored.
SP2-0734: unknown command beginning "HOW MUCH ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "CALL 800-..." - rest of line ignored.
SP2-0042: unknown command "" - rest of line ignored.
SP2-0042: unknown command "')" - rest of line ignored.

mathieu_cupryk

ASKER

insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004', T S T T

IND.SQUARE/EDWARD ST

VAT REG# 100476

Bill Payment 2004/07/1 1.00

Account: 91013698-0000

Chantal Rigaud

A/c Balance: 2,534.33

TOTAL 1.00

TENDERED

Cash 1.00

TOTAL TENDERED 1.00

CHANGE 0.00

Payment No: 42884297 Cashier: 888888

18-Oct-2004 09:12

IF YOU NEED TO KNOW

HOW MUCH YOU OWE !

CALL 800-BILL (2455)

');

mathieu_cupryk

ASKER

insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004', ' T S T T

IND.SQUARE/EDWARD ST

VAT REG# 100476

Bill Payment 2004/07/1 1.00

Account: 91013698-0000

Chantal Rigaud

A/c Balance: 2,534.33

TOTAL 1.00

TENDERED

Cash 1.00

TOTAL TENDERED 1.00

CHANGE 0.00

Payment No: 42884297 Cashier: 888888

18-Oct-2004 09:12

IF YOU NEED TO KNOW

HOW MUCH YOU OWE !

CALL 800-BILL (2455)

');

mathieu_cupryk

ASKER

T S T T \n\nIND.SQUARE/EDWARD ST\n\nVAT REG# 100476 \n\nBill Payment 2004/07/1 100.00 \n\nAccount: 91013698-0000 \n\n Chantal Rigaud \n\nA/c Balance: 2,566.33 \n\n \n\n \n\nTOTAL 100.00 \n\n \n\nTENDERED \n\n Cash 100.00 \n\n TOTAL TENDERED 100.00 \n\n \n\nCHANGE 0.00 \n\n
Answered my own question.

ASKER CERTIFIED SOLUTION

hanzpk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mathieu_cupryk

ASKER

Instead of using the square boxes I used \n
This I will try thanks. Looks good.:-)