How to suppress the Oracle input window without using set sets off

Navigation
0

I need to insert an image into oracle using php, but after I convert it to insert into the database, it receives some characters & in the middle of the string, this character in Oracle triggers an input screen, when this input screen is fired, php gets lost and throws an exception, I tried to use set define off to suppress the input screen but without success, my user of oracle does not have this permission and there is no way I can get another user, what would be the way around this question? the question would be, how to suppress the oracle input screen without using the set define off.

This is the input screen that I need to delete:

    
asked by anonymous 06.03.2017 / 17:09

1 answer

1
SET ESCAPE '\'   

CREATE TABLE TABELA ( 
   C1 VARCHAR(10),
   C2 VARCHAR(10))

INSERT INTO TABELA VALUES ( 'CAR\&LOS', 'ANDOR\&INHA')
    
06.03.2017 / 18:16
Unity 2d - Enemy following player [closed] Ajax sending model to controller