Re: forms_ddl question
Date: Tue, 28 Jul 1998 12:20:09 -0700
Message-ID: <6pl89l$137$1_at_nnrp03.primenet.com>
Use two single quotes within the statement.
Also concatenante all string before in a variable and pass it on as a statement.
EG:
declare
stmt1 varchar2(400);
begin
stmt1 := 'update emp where emp_name like ''JOHN%'' and emp_id is not null';
forms_ddl(stmt1);
end;
HTH
Prasad Chavali
pchavali_at_assettech.com
Brett Moran wrote in message <35BCD140.95FB4771_at_isus.msstate.edu>...
>I am trying to utilize the forms_ddl function and am trying to include
>an SQL statement that has single quotes in it. These single quotes
>appear to interfere with the single quotes required in the syntax of the
>function. How do get the single quotes in the sql to cooperate with the
>single quotes that are 'wrapped around it'? Thanks.
>
>Brett Moran
>bmoran_at_isus.msstate.edu
>
Received on Tue Jul 28 1998 - 21:20:09 CEST