OraFAQ Forum: Client Tools » How to avoid Ampersand ( & )symbol issue, while execute the procedure..?

Home » Other » Client Tools » How to avoid Ampersand ( & )symbol issue, while execute the procedure..? (oracle 9.0.1 in UNIX environment & front end client/server application is windows environment)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to avoid Ampersand ( & )symbol issue, while execute the procedure..? [message #302133]

Sat, 23 February 2008 19:52

gksenthilkumar
Messages: 23
Registered: November 2007
Location: india

Junior Member

In the procedure, passing three input values and third input value passing with & ampersand sysbol.

It is asking input value, while exceute the procedure.

EXEC spu_delete('DELETE','DELETE1','A&T-BOSS-10');

How to avoid this Ampersand ( & )symbol issue with out using SET DEFINE OFF / SET SCAN OFF, while execute the procedure..?.

Because, executing through fron-end with batch job in the UNIX server; we cannt use / pass the SET operation.

any alternate for execute this procedure ?

Report message to a moderator

Re: How to avoid Ampersand ( & )symbol issue, while execute the procedure..? [message #302134 is a reply to message #302133]

Sat, 23 February 2008 19:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

scott@9i > exec foo('AT'||CHR(38)||'T');
input is AT&T

Report message to a moderator

Re: How to avoid Ampersand ( & )symbol issue, while execute the procedure..? [message #302135 is a reply to message #302134]

Sat, 23 February 2008 20:06

gksenthilkumar
Messages: 23
Registered: November 2007
Location: india

Junior Member

my procedure contains only three input parameter & also i am passing through front-end client/server application in windows environment & the database and SQL*Plus in the UNIX environment.

How can i pass this input value = 'A&T-BOSS-10' in that procedure....

Report message to a moderator

Re: How to avoid Ampersand ( & )symbol issue, while execute the procedure..? [message #302136 is a reply to message #302134]

Sat, 23 February 2008 20:08

gksenthilkumar
Messages: 23
Registered: November 2007
Location: india

Junior Member

yeah, understand; thank you... Smile

Report message to a moderator

Previous Topic:	tools
Next Topic:	Toad Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 02:12:04 CST 2025