OraFAQ Forum: Weblogic & Application Server » Double quote in Web pl.sql

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Double quote in Web pl.sql

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

Double quote in Web pl.sql [message #154656]

Mon, 09 January 2006 23:41

rawat_me
Messages: 45
Registered: September 2005

Member

Hi Gurus,
I have a problem when loading the Web pl/sql pages.
I have Web pages which are generated by PL/SQL Packages or procedures. When i am editing one report and inserting Double QUOTE in the varchar field everything is fine that is the value is inserted in the database . But when i am reopening my similar page for editing it is giving problem in loading and the problem is coming when extracting Double quote from the database and generating page.

So i tried with inputing single quote in the varchar field and every thing is fine and in the second time also the page is displaying and i am to edit second time also .

so please tell me why the error is coming in double quote as my business requiremnt is inserting double quote.

thanks
rawat

Report message to a moderator

Re: Double quote in Web pl.sql [message #155020 is a reply to message #154656]

Wed, 11 January 2006 15:14

andrew again
Messages: 2577
Registered: March 2000

Senior Member

It sounds like the " is beining interpreted in your HTML. You should escape strings coming out of the database.

select htf.escape_sc('this"quote') from dual;
this&quot;quote

Report message to a moderator

Previous Topic:	Mass Test Forms Application (Forms Applet)
Next Topic:	sys.dbms_trace?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 22:31:26 CST 2025