-
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....');
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|