Home » SQL & PL/SQL » SQL & PL/SQL » Embedded single quotes in values passed as parameters
Embedded single quotes in values passed as parameters [message #39252] Mon, 01 July 2002 07:00 Go to next message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
I have strings that are being passed into parameters that contain embedded single quotes. Obviously this fails the insert and
update statements. How can I handle these inside stored procedure?

Thanks
Rick
Re: Embedded single quotes in values passed as parameters [message #39254 is a reply to message #39252] Mon, 01 July 2002 07:09 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you need to take care of ' single quotes.
something like this.
 
SQL> ed
Wrote file afiedt.buf

  1  create or replace procedure insert_test
  2  (p_in in varchar2)
  3  as
  4  begin
  5  insert into test values (p_in);
  6* end;
  7  /

Procedure created.

SQL> exec insert_test('castra''de augurta');

PL/SQL procedure successfully completed.

SQL> select * from test;

NAME
------------------------------
castra'de augurta

1 row selected.
Previous Topic: COALESCE declaration
Next Topic: Portability of PL/SQL
Goto Forum:
  


Current Time: Thu Mar 28 15:52:05 CDT 2024