OraFAQ Forum: Forms » Problem calling database procedure

Home » Developer & Programmer » Forms » Problem calling database procedure (Forms 6i)

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

Problem calling database procedure [message #460659]

Mon, 14 June 2010 00:12

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

i m creating a procedure in Database...
and now can i call it by using forms ...

if yes then how ...

Report message to a moderator

Re: Problem calling database procedure [message #460664 is a reply to message #460659]

Mon, 14 June 2010 00:52

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

Senior Member
Account Moderator

Call it as you'd do that in any PL/SQL program - by specifying its name and, eventually, parameters it requires. No difference at all.

Report message to a moderator

Re: Problem calling database procedure [message #460667 is a reply to message #460664]

Mon, 14 June 2010 00:57

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

Thanks for your reply Littlefoot

my procedure name is "abc" and i created it in the database...
and now i write this line for call that database procedure in the form.

abc(myparameter);

but when i compile my when_button_pressed trigger it raised the following error ;

PDE-PSD001 Could not resolve reference to <Unknown Program Unit> while loading Block P49_13_JUN_201020_52_48.

Report message to a moderator

Re: Problem calling database procedure [message #460692 is a reply to message #460664]

Mon, 14 June 2010 04:03

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

hi littlefoot..

please can you tell me that how can i call procedure.. from forms

i mention my step by step which i done ....in previous post i think which you not read till now....

please sir tell me about that... or any other solution..

Report message to a moderator

Re: Problem calling database procedure [message #460697 is a reply to message #460692]

Mon, 14 June 2010 04:37

sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )

Senior Member

Dear Waqas ,

Make sure that your form builder is connected to the same schema and database in which you create the procedure.
or you can create a synonym for the procedure in database.

Regards
S A S I

Report message to a moderator

Re: Problem calling database procedure [message #460698 is a reply to message #460697]

Mon, 14 June 2010 04:39

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

hi sasipalarivattom

yes sir.. i m connected with schema and database in which i create the procedure.

Report message to a moderator

Re: Problem calling database procedure [message #460701 is a reply to message #460698]

Mon, 14 June 2010 04:41

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Show us the actual procedure definition and the actual form code you use to call it.

Report message to a moderator

Re: Problem calling database procedure [message #460704 is a reply to message #460701]

Mon, 14 June 2010 04:50

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

Senior Member
Account Moderator

Try to qualify the procedure with schema name. For example, if schema (i.e. procedure owner) is "allianz", then call it as

Code: [Select all] [Show/ hide]

allianz.abc(some_parameter);

Report message to a moderator

Re: Problem calling database procedure [message #460736 is a reply to message #460698]

Mon, 14 June 2010 05:48

sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )

Senior Member

Dear Waqas ,

Expand Database Objects in the form builder.
And make sure that your procedure is listed under the schema name.

Regards
S A S I

Report message to a moderator

Re: Problem calling database procedure [message #668672 is a reply to message #460667]

Thu, 08 March 2018 11:37

anto1989caceres
Messages: 4
Registered: July 2016
Location: PARAGUAY

Junior Member

YO estoy ahora con el mismo problema, ya lei todo pero no hay solucion, despues de levantar un BK de oracle osea un DMP , ya no me permitio compilar ningun formulario que contenga una funcion o algo asi, se sale el mismo sms de error, es un oracle form y reporte 6i .

ayudaaaaaaaa

Report message to a moderator

Re: Problem calling database procedure [message #668689 is a reply to message #668672]

Fri, 09 March 2018 05:35

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

translated (via google translate):
"I am now with the same problem, I read everything but there is no solution, after lifting a BK from oracle a DMP, I was not allowed to compile any form that contains a function or something like that, the same error sms, is an oracle form and report 6i."

1) This is an english forum. Most of us don't speak Spanish. If you can't write English then I suggest you use google translate so the rest of us don't have to.
2) What's a BK?
3) What DMP?

Report message to a moderator

Re: Problem calling database procedure [message #668711 is a reply to message #668689]

Mon, 12 March 2018 06:16

anto1989caceres
Messages: 4
Registered: July 2016
Location: PARAGUAY

Junior Member

Now I am with the same problem, I already read everything but there is no solution, after building an Oracle Backup, which would be a DMP point file, I was not allowed to compile any form that contains a function or something procedure, sometimes it does not recognize some tables when trying to complilar, but the functions and other tables work normally when executing, my problem is only when compiling the form, I get the same error message, it is a form of oracle form 6i, the error is equal to the title that started this debate ...

Attachment: Captura.JPG
(Size: 130.86KB, Downloaded 1870 times)

Report message to a moderator

Re: Problem calling database procedure [message #668712 is a reply to message #668711]

Mon, 12 March 2018 06:39

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is form builder connecting to the DB as the owner of the procedures/functions/tables?
If it is then I can only assume some kind of bug
If it isn't then it's probably missing grants/synonyms.

Report message to a moderator

Re: Problem calling database procedure [message #668713 is a reply to message #668712]

Mon, 12 March 2018 06:54

anto1989caceres
Messages: 4
Registered: July 2016
Location: PARAGUAY

Junior Member

What can I check? if it connects as the owner of the BD, could that be the problem? with the synonyms and other permissions are all correct

Report message to a moderator

Re: Problem calling database procedure [message #668717 is a reply to message #668713]

Mon, 12 March 2018 08:57

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

not sure what owner of BD is.

Report message to a moderator

Re: Problem calling database procedure [message #668718 is a reply to message #668717]

Mon, 12 March 2018 10:08

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

did you mean owner of the DB?
That would be sys and you shouldn't be using sys for anything to do with forms.

Report message to a moderator

Re: Problem calling database procedure [message #668724 is a reply to message #668711]

Mon, 12 March 2018 12:45

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

anto1989caceres wrote on Mon, 12 March 2018 07:16

Now I am with the same problem, I already read everything but there is no solution, after building an Oracle Backup, which would be a DMP point file

An export, which will make a .dmp file is not a backup.
It sounds like you may have run an export. Did you do an import?
What was the command line you used to do the export and the import? Maybe it didn't export grants? Maybe it was a table only export. An export like that will not export any synonyms.

Report message to a moderator

Previous Topic:	Ora-302000
Next Topic:	Asking for search algorithm

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 18:44:54 CDT 2025