Home » SQL & PL/SQL » SQL & PL/SQL » Problems with special HTML characters and PLSQL packages (Oracle 10gR2 unbreakable Linux)
Problems with special HTML characters and PLSQL packages [message #329743] Thu, 26 June 2008 07:14 Go to next message
xokas11
Messages: 28
Registered: January 2008
Location: Guadalajara, Spain
Junior Member
Hello
I'm having problems with an insert procedure. The thing is the procedure is called from a PHP5 script that receives it´s parameters from a WYSIWYG HTML editor. I'm working in Spain and here we use a couple of characters (,,,,e,,,,,,,) that in HTML are represented like this:

, -> &ntilde,Ñ
, -> ´,&Acute;
, -> &ocute;,&Ocute;
, -> &ecute;,&Ecute;
, -> &icute;,&Icute;
, -> &ucute;,&Ucute;

So when I try to insert them the insert fails but if I call the procedure from SQL Developer and use the "SET DEFINE OFF" or "SET DEFINE $" it works.
My question: Is there any possibility to call the "set define off" command from outside the SQL Developer, preferably from PHP5 or is there any command that alters these behaviors permanently, for example, changing the variable define character or being able to disable defining variables
Thanks, Joaqun.
Re: Problems with special HTML characters and PLSQL packages [message #329755 is a reply to message #329743] Thu, 26 June 2008 07:36 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any possibility to call the "set define off" command from outside the SQL Developer, preferably from PHP5

It is useful in SQL Developer or SQL*Plus because & is interpreted but it is useless in PHP.

Regards
Michel

Previous Topic: query
Next Topic: how to display row to column ..
Goto Forum:
  


Current Time: Sun Dec 04 10:57:18 CST 2016

Total time taken to generate the page: 0.10412 seconds