Urgent!!! [message #21180] |
Wed, 17 July 2002 06:48 |
Try
Messages: 8 Registered: July 2002
|
Junior Member |
|
|
I try to insert data that come from a client(web application)
How to take care if single quote(') is entered in one of the inputs
i get an error ORA-00917: missing comma because of this ' in input(text field)
thanks in advance
|
|
|
Re: Urgent!!! [message #21183 is a reply to message #21180] |
Wed, 17 July 2002 09:38 |
André ALIMBA
Messages: 16 Registered: April 2002
|
Junior Member |
|
|
Use SQL*LOADER Utility
The content of the controle file
Specify the "enclose by" parameter
...
-- Controle file
load data
infile 'example.dat'
into table example
fields terminated by ',' optionally enclosed by '"'
(col1 char(5),
col2 char(7))
-- End
André ALIMBA
Chef de Projet BEAC
|
|
|
|