OraFAQ Forum: Forms » Forms

Home » Developer & Programmer » Forms » Forms_Ddl Problem

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

Forms_Ddl Problem [message #217710]

Mon, 05 February 2007 00:14

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi Guys
I am using form 6 and i am trying to use forms_ddl('commit') from a schema to diffent schema...
But there is no changes....????
Shefeeq

Report message to a moderator

Re: Forms_Ddl Problem [message #217716 is a reply to message #217710]

Mon, 05 February 2007 00:52

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, you can not issue a COMMIT connected as 'user A' which will commit transactions in 'schema B'.

Report message to a moderator

Re: Forms_Ddl Problem [message #217723 is a reply to message #217716]

Mon, 05 February 2007 01:35

Frank
Messages: 7901
Registered: March 2000

Senior Member

Commit has nothing to do with schemas. Commit ends a transaction and transactions can span multiple schemas.
Don't you mean you try to commit another SESSION?
(That is not possible)

Report message to a moderator

Re: Forms_Ddl Problem [message #217752 is a reply to message #217723]

Mon, 05 February 2007 05:02

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi
I am login as A ,and doing some update/insert stmnt in b
then using forms_ddl('COMMIT')
,is not working...

Eg:=
Update b.table_name set fld = 'XXXXX' where fld2 = 'C';
forms_ddl('COMMIT')

it won't work....?
Thanks & regards
Shefeeq

Report message to a moderator

Re: Forms_Ddl Problem [message #217753 is a reply to message #217752]

Mon, 05 February 2007 05:09

Frank
Messages: 7901
Registered: March 2000

Senior Member

Quote:

it won't work....?

What does that mean? Do you get an error? How exactly do you check what was updated?

Report message to a moderator

Re: Forms_Ddl Problem [message #217767 is a reply to message #217753]

Mon, 05 February 2007 06:22

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

hi Frank
I am trying to update a value in diffent schema.
Insert command is working in this case,i don't know why the updation command ...
update A.table set fld = 'X' where fld2 = 'Y'
Forms_Ddl('COMMIT');
is not updating.

insert into A.table values ('X','Y','Z') ;
Forms_Ddl('COMMIT');

This is inserting the record....

Thanks & Regards
Shefeeq

Report message to a moderator

Re: Forms_Ddl Problem [message #217771 is a reply to message #217753]

Mon, 05 February 2007 06:58

Frank
Messages: 7901
Registered: March 2000

Senior Member

Frank wrote on Mon, 05 February 2007 12:09

How exactly do you check what was updated?

Report message to a moderator

Re: Forms_Ddl Problem [message #217774 is a reply to message #217767]

Mon, 05 February 2007 07:18

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you see this:

insert into A.table values ('X','Y','Z')

but you do not see this:

update A.table set fld = 'X' where fld2 = 'Y'

perhaps no record satisfies condition WHERE fld2 = 'Y'

Report message to a moderator

Re: Forms_Ddl Problem [message #217918 is a reply to message #217774]

Tue, 06 February 2007 01:48

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi Guys
I can update the data in sql plus using same qury.i think the updation is not possible in different schema from the forms...?,
Regards

Shefeeq...

Report message to a moderator

Re: Forms_Ddl Problem [message #217943 is a reply to message #217918]

Tue, 06 February 2007 03:08

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If such an UPDATE statement works from SQL*Plus, it will work in Forms too. I believe you do have required privileges, don't you?

Did you try to create a synonym in user A's schema and update a synonym (instead of a table in schema B)?

Is there an exception handler in a form which prevents you from seeing an error which, possibly, occurred?

Try to put MESSAGE commands into this PL/SQL procedure/trigger (which is supposed to do the update) so that you could follow what is happening.

Report message to a moderator

Re: Forms_Ddl Problem [message #217988 is a reply to message #217943]

Tue, 06 February 2007 05:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Instead of "Forms_Ddl('COMMIT');" use 'standard.commit;'.

David

Report message to a moderator

Re: Forms_Ddl Problem [message #218003 is a reply to message #217988]

Tue, 06 February 2007 06:05

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi Guys
I got it.... At last............

Tnak you for ur support & copeartion.
Its updating the items,but before updation i am running
the vaildation trigger once more,there it reassign old values and
updating....,
Sorry ,for taking ur valuebale time and thoughts...
Thanks & Regards
Shefeeq...

Report message to a moderator

Previous Topic:	Text_io
Next Topic:	Problem with post text item trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:28:29 CDT 2024