OraFAQ Forum: Server Administration » Querying single quotes in varchar2 field using Run

Home » RDBMS Server » Server Administration » Querying single quotes in varchar2 field using Run_Product for Reports.

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

Querying single quotes in varchar2 field using Run_Product for Reports. [message #374558]

Mon, 18 June 2001 15:07

Shubha
Messages: 8
Registered: June 2001

Junior Member

Hi everyone,

Using forms V4.5 a form is being built through which reports are ran using run_product built in. The problem I am having is querying a varchar2 field having a single quote as a part of the data saved. When replaced by double quotes while querying the same field from report designer, it works.
Can anyone please suggest any work around for this query from forms?Thank you.

Report message to a moderator

Previous Topic:	SELECT STATEMENT
Next Topic:	Querying single quotes in varchar2 field using Run_Product for Reports.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 22 20:40:15 CDT 2026