Home » SQL & PL/SQL » 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)
How to avoid Ampersand ( & )symbol issue, while execute the procedure..? [message #302133] Sat, 23 February 2008 19:52 Go to next message
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 ?
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
scott@9i > exec foo('AT'||CHR(38)||'T');
input is AT&T
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 Go to previous messageGo to next message
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....
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 Go to previous message
gksenthilkumar
Messages: 23
Registered: November 2007
Location: india
Junior Member
yeah, understand; thank you...Smile
Previous Topic: tools
Next Topic: Toad Error
Goto Forum:
  


Current Time: Tue Dec 06 06:33:55 CST 2016

Total time taken to generate the page: 0.09109 seconds