Inserting a singlecote ' into tables

Hi,
I am trying to insert the data , that I get from some session tracking program. I receive the filename and the sitename.

some times the filename comes as
'kid's play room','http://www.kidsplayroom.com'

How do it insert this data, as it is without changing the form.

When I try to insert this using my procedure,

proc_load('kid'splay room', 'http://www....');
I get an error,

Can anyone help me in loading this data as it is

I am using oracle 8.1.6
Badrinath

hi,

u might want to try this:

proc_load('kid''splay room', 'http://www....');

(two single quotes between d and s)

[Edited by WengLi on 02-15-2001 at 06:01 PM]

Try this.

exec proc_load(''''||'kid'||''''||'s play room',...);

Thanks,
It worked the way Wengli said
Badrinath

One more, How do I insert ampersand (&) into the tables in the insert statements.

And also through the procedure.

Example:

proc_load('kid&youth's play room', 'http://www....');

Badrinath

try this ver simple

proc_load('kid \&youth's play room', 'http://www....');