Home » Developer & Programmer » Forms » Forms_Ddl Problem
icon6.gif  Forms_Ddl Problem [message #217710] Mon, 05 February 2007 00:14 Go to next message
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
Re: Forms_Ddl Problem [message #217716 is a reply to message #217710] Mon, 05 February 2007 00:52 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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'.
Re: Forms_Ddl Problem [message #217723 is a reply to message #217716] Mon, 05 February 2007 01:35 Go to previous messageGo to next message
Frank
Messages: 7880
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)
Re: Forms_Ddl Problem [message #217752 is a reply to message #217723] Mon, 05 February 2007 05:02 Go to previous messageGo to next message
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
Re: Forms_Ddl Problem [message #217753 is a reply to message #217752] Mon, 05 February 2007 05:09 Go to previous messageGo to next message
Frank
Messages: 7880
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?
Re: Forms_Ddl Problem [message #217767 is a reply to message #217753] Mon, 05 February 2007 06:22 Go to previous messageGo to next message
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
Re: Forms_Ddl Problem [message #217771 is a reply to message #217753] Mon, 05 February 2007 06:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Frank wrote on Mon, 05 February 2007 12:09
How exactly do you check what was updated?


Re: Forms_Ddl Problem [message #217774 is a reply to message #217767] Mon, 05 February 2007 07:18 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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'
Re: Forms_Ddl Problem [message #217918 is a reply to message #217774] Tue, 06 February 2007 01:48 Go to previous messageGo to next message
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...
Re: Forms_Ddl Problem [message #217943 is a reply to message #217918] Tue, 06 February 2007 03:08 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Forms_Ddl Problem [message #217988 is a reply to message #217943] Tue, 06 February 2007 05:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Instead of "Forms_Ddl('COMMIT');" use 'standard.commit;'.

David
Re: Forms_Ddl Problem [message #218003 is a reply to message #217988] Tue, 06 February 2007 06:05 Go to previous message
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...
Previous Topic: Text_io
Next Topic: Problem with post text item trigger
Goto Forum:
  


Current Time: Fri Dec 09 07:46:36 CST 2016

Total time taken to generate the page: 0.10796 seconds