Home » Developer & Programmer » Forms » Problem calling database procedure (Forms 6i)
Problem calling database procedure [message #460659] Mon, 14 June 2010 00:12 Go to next message
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 ...
Re: Problem calling database procedure [message #460664 is a reply to message #460659] Mon, 14 June 2010 00:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Problem calling database procedure [message #460667 is a reply to message #460664] Mon, 14 June 2010 00:57 Go to previous messageGo to next message
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.
Re: Problem calling database procedure [message #460692 is a reply to message #460664] Mon, 14 June 2010 04:03 Go to previous messageGo to next message
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..
Re: Problem calling database procedure [message #460697 is a reply to message #460692] Mon, 14 June 2010 04:37 Go to previous messageGo to next message
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
Re: Problem calling database procedure [message #460698 is a reply to message #460697] Mon, 14 June 2010 04:39 Go to previous messageGo to next message
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.
Re: Problem calling database procedure [message #460701 is a reply to message #460698] Mon, 14 June 2010 04:41 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Show us the actual procedure definition and the actual form code you use to call it.
Re: Problem calling database procedure [message #460704 is a reply to message #460701] Mon, 14 June 2010 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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
allianz.abc(some_parameter);
Re: Problem calling database procedure [message #460736 is a reply to message #460698] Mon, 14 June 2010 05:48 Go to previous messageGo to next message
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
Re: Problem calling database procedure [message #668672 is a reply to message #460667] Thu, 08 March 2018 11:37 Go to previous messageGo to next message
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
Re: Problem calling database procedure [message #668689 is a reply to message #668672] Fri, 09 March 2018 05:35 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?


Re: Problem calling database procedure [message #668711 is a reply to message #668689] Mon, 12 March 2018 06:16 Go to previous messageGo to next message
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 1301 times)
Re: Problem calling database procedure [message #668712 is a reply to message #668711] Mon, 12 March 2018 06:39 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Problem calling database procedure [message #668713 is a reply to message #668712] Mon, 12 March 2018 06:54 Go to previous messageGo to next message
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
Re: Problem calling database procedure [message #668717 is a reply to message #668713] Mon, 12 March 2018 08:57 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
not sure what owner of BD is.
Re: Problem calling database procedure [message #668718 is a reply to message #668717] Mon, 12 March 2018 10:08 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Problem calling database procedure [message #668724 is a reply to message #668711] Mon, 12 March 2018 12:45 Go to previous message
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.
Previous Topic: Ora-302000
Next Topic: Asking for search algorithm
Goto Forum:
  


Current Time: Fri Mar 29 01:19:38 CDT 2024