OraFAQ Forum: Forms » Executing DDL statements in Forms

Home » Developer & Programmer » Forms » Executing DDL statements in Forms

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

Executing DDL statements in Forms [message #79760]

Tue, 09 July 2002 10:03

Godwin
Messages: 37
Registered: January 2002

Member

I want to execute this DDL statement in forms 6 but getting some compilation error:
e.g
FORMS_DDL('create view Rank_V
as select paanum,decode( paapcde,1,'SM',2,'SM',3,'SM',4,'SM',5,'SS',6,'JS',7,'SM',8,'SM',9,'SM',10,'SM',11,'SS',12,'CA',13,'JS',14,'DE',15,'TA',16,'VS',17,'GA',20,'PT',25,'PE',27,'NS',30,'HA',35,'EE') rank
from paapr1');

but get the error message "Encounted the symbol "SM" when expecting one of the ff .(),*@%$/=.+</> is not range...

Does it have to do with the Character SM and how do i got by it.
Thanks.

Report message to a moderator

Re: Executing DDL statements in Forms [message #79764 is a reply to message #79760]

Tue, 09 July 2002 20:56

Subhash
Messages: 105
Registered: October 2001

Senior Member

instead of using one single quote u must use two
Eg: FORMS_DDL('create view Rank_V
as select paanum,decode( paapcde,1,''SM'',2,''SM'',3,''SM'',4,''SM'',5,''SS'',6,''JS'',7,''SM'',8,''SM'',9,''SM'',10,''SM'',11,''SS'',12,''CA'',13,''JS'',14,''DE'',15,''TA'',16,''VS'',17,''GA'',20,''PT'',25,''PE'',27,''NS'',30,''HA'',35,''EE'') rank
from paapr1');

Report message to a moderator

Previous Topic:	NO_DATA_FOUND??????
Next Topic:	variable := NAME_IN('list_name');

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 03:49:48 CST 2025