OraFAQ Forum: Forms » forms11g ora-04067

Home » Developer & Programmer » Forms » forms11g ora-04067

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

forms11g ora-04067 [message #596434]

Mon, 23 September 2013 03:17

zuzzi
Messages: 39
Registered: April 2005

Member

Help me,

i've forms11g with db oracle 11. i've a db-link to oracle 9 on a procedure, but when the form calls the procedure i've an error " ORA-04067: not executed, stored procedure "PUBLIC.INSASS" does not exist"

If i launch the procedure from pl-sql it is is executed currectly.

Where is the problem?

Thanks Umberto

Sorry for my english.

Report message to a moderator

Re: forms11g ora-04067 [message #596435 is a reply to message #596434]

Mon, 23 September 2013 03:18

Maaher
Messages: 7065
Registered: December 2001

Senior Member

So, you can call the procedure from the 11g database, but not from Forms connecting to the same database schema?

MHE

Report message to a moderator

Re: forms11g ora-04067 [message #596436 is a reply to message #596435]

Mon, 23 September 2013 03:37

zuzzi
Messages: 39
Registered: April 2005

Member

Yes,
all procedures listed on oraqle 11 work
the stored procedure is present in other database schema (oracle 9i) with db link and forms is not executed it.

Report message to a moderator

Re: forms11g ora-04067 [message #596437 is a reply to message #596436]

Mon, 23 September 2013 03:59

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

Senior Member
Account Moderator

A procedure is created in 9i.
Now, in 11g, create a synonym for that procedure.
In a form, call the procedure over a synonym, not via database link.

Report message to a moderator

Re: forms11g ora-04067 [message #596440 is a reply to message #596437]

Mon, 23 September 2013 04:44

zuzzi
Messages: 39
Registered: April 2005

Member

to create a synonym on 11 g to see the procedure in 9i, I have to create a dlink is it correct?

Report message to a moderator

Re: forms11g ora-04067 [message #596441 is a reply to message #596440]

Mon, 23 September 2013 04:50

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

Senior Member
Account Moderator

You already have it, don't you?

Report message to a moderator

Re: forms11g ora-04067 [message #596442 is a reply to message #596441]

Mon, 23 September 2013 05:00

zuzzi
Messages: 39
Registered: April 2005

Member

Yes,
i call the procedure with synonym but i've the error ora-04067. If i create another synonym based on first synonym the error is ora-04066

Report message to a moderator

Re: forms11g ora-04067 [message #596443 is a reply to message #596442]

Mon, 23 September 2013 05:08

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

Senior Member
Account Moderator

Huh, no ... I didn't mean that you should create one synonym for another, that won't solve the problem, I'm afraid.

I thought that you called the procedure via database link at the first place, such as

your_procedure@db_link_name;

Did you try that too?

Report message to a moderator

Re: forms11g ora-04067 [message #596444 is a reply to message #596443]

Mon, 23 September 2013 05:16

zuzzi
Messages: 39
Registered: April 2005

Member

yes , and the error is ora-02064 distributed operation not supported ora-06512 line 164(in this point ther0s commit).

Report message to a moderator

Re: forms11g ora-04067 [message #596445 is a reply to message #596444]

Mon, 23 September 2013 05:19

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

Senior Member
Account Moderator

If nothing else works, maybe you'll have to create a procedure in your 11g database. If it does *something* with tables that reside in 9i, that procedure will have to use database link in order to access those tables (or you'll create synonyms).

Report message to a moderator

Re: forms11g ora-04067 [message #596447 is a reply to message #596445]

Mon, 23 September 2013 05:25

zuzzi
Messages: 39
Registered: April 2005

Member

the procedure is located on database who is not mine; i've only privileges on that procedure.

Report message to a moderator

Re: forms11g ora-04067 [message #596450 is a reply to message #596447]

Mon, 23 September 2013 05:48

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

Senior Member
Account Moderator

Sorry, I don't have any other ideas (apart from what I already said). Wait a little bit longer, maybe someone else knows the answer to your question (and/or Google some more).

Report message to a moderator

Re: forms11g ora-04067 [message #596453 is a reply to message #596450]

Mon, 23 September 2013 06:01

zuzzi
Messages: 39
Registered: April 2005

Member

thanks

Report message to a moderator

Re: forms11g ora-04067 [message #596461 is a reply to message #596453]

Mon, 23 September 2013 07:44

zuzzi
Messages: 39
Registered: April 2005

Member

I solved, i have included inthe Function the instruction "PRAGMA AUTONOMOUS_TRANSACTION"

Report message to a moderator

Re: forms11g ora-04067 [message #596462 is a reply to message #596461]

Mon, 23 September 2013 08:21

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

zuzzi -

I read the entire post and understood the issue when LF described properly. I am afraid, using autonomous transaction might introduce side effects. You have mentioned that there is a COMMIT at line 164 where you received the error. So, why is there a commit inside the procedure?

Report message to a moderator

Re: forms11g ora-04067 [message #596463 is a reply to message #596462]

Mon, 23 September 2013 09:10

zuzzi
Messages: 39
Registered: April 2005

Member

The procedure is not mine, there is the COMMIT inside because there are some insert before.
Have you got another solution?

Thanks
Umberto

Report message to a moderator

Re: forms11g ora-04067 [message #596481 is a reply to message #596463]

Mon, 23 September 2013 12:44

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

zuzzi wrote on Mon, 23 September 2013 19:40

The procedure is not mine, there is the COMMIT inside because there are some insert before.

It is implicitly understood that a commit is there due to some DML transactions. My question is why you think that autonomous transaction will fix the issue. Understand that a error is thrown while you commit the transaction, so autonomous trqnsaction will hide the actual issue here.

Can you post your code and show how autonomous transaction fixed the issue.

Regards,
Lalit

Report message to a moderator

Re: forms11g ora-04067 [message #596501 is a reply to message #596481]

Tue, 24 September 2013 01:54

zuzzi
Messages: 39
Registered: April 2005

Member

This is my code

Attachment: mycode.txt
(Size: 5.15KB, Downloaded 1118 times)

Report message to a moderator

Re: forms11g ora-04067 [message #596502 is a reply to message #596501]

Tue, 24 September 2013 01:56

zuzzi
Messages: 39
Registered: April 2005

Member

This is function with autonomous trqnsaction on db oracle 9i

Attachment: function.txt
(Size: 4.63KB, Downloaded 1043 times)

Report message to a moderator

Previous Topic:	How To Run Forms 6i from Server without Runtime Installation on Client Pc
Next Topic:	Edit and Save image Item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:54:39 CDT 2024