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
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]
exec proc_load(''''||'kid'||''''||'s play room',...);
It worked the way Wengli said
One more, How do I insert ampersand (&) into the tables in the insert statements.
And also through the procedure.
proc_load('kid&youth's play room', 'http://www....');
try this ver simple
proc_load('kid \&youth's play room', 'http://www....');
Click Here to Expand Forum to Full Width