Home » SQL & PL/SQL » SQL & PL/SQL » Function is not working in distributed transaction (with dblink)
Function is not working in distributed transaction (with dblink) [message #248203] Thu, 28 June 2007 04:41 Go to next message
vilas_more
Messages: 2
Registered: September 2005
Junior Member
I am working to two databases, and I have created database link between these two datbases

I am facing problem while insert query, this insert query is depends on select query which include one function.

e.g
INSERT INTO DBACCOUNTS@REMDATABSE (ACCOUNTID, NAME, TYPE, DEBITBALANCE, CREDITBALANCE)
(SELECT ACCOUNTID, NAME, TYPE, F_GETBALANCE('D'), F_GETBALANCE('C')
FROM DBACCOUNTS
WHERE CREATEDATE >= TO_DATE('01-05-2007', 'DD-MM-YYYY'))

My Select query runs ok, but with insert statement server gives error 'GLOBAL_NAME' must be 'false'
and after setting GLOBAL_NAME to false it give ORA error.
When I hardcode the values for insert it runs fine.

Please suggest what to do?

TIA
Re: Function is not working in distributed transaction (with dblink) [message #248237 is a reply to message #248203] Thu, 28 June 2007 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
after setting GLOBAL_NAME to false it give ORA error.

Which ones?

What are the Oracle versions? both side.

Regards
Michel
Re: Function is not working in distributed transaction (with dblink) [message #248297 is a reply to message #248237] Thu, 28 June 2007 10:14 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
My Select query runs ok, but with insert statement server gives error 'GLOBAL_NAME' must be 'false'
and after setting GLOBAL_NAME to false it give ORA error.
When I hardcode the values for insert it runs fine.



Wheres ORA error.
Re: Function is not working in distributed transaction (with dblink) [message #248309 is a reply to message #248297] Thu, 28 June 2007 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Was this not what I asked 4 hours before?

Regards
Michel
Re: Function is not working in distributed transaction (with dblink) [message #248317 is a reply to message #248309] Thu, 28 June 2007 11:12 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Laughing
didnt notice that.
Previous Topic: single quots problem
Next Topic: Update statement generates error - SQL command not ended properly
Goto Forum:
  


Current Time: Sun Dec 04 20:32:48 CST 2016

Total time taken to generate the page: 0.19530 seconds