Home » Developer & Programmer » Forms » how to create and use an pl/sql library with .ppl & to attached .pll library in form 10g (merged
how to create and use an pl/sql library with .ppl & to attached .pll library in form 10g (merged [message #394473] Fri, 27 March 2009 05:19 Go to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

I have create an pl/sql library and one procedure and compile and saved it with .pll .
but when i atteched it with another form and call its procedure it does not work.why.
How can i use procedure of pl/sql library.
tell me about the creation and using of .pll procedure.
thanks
Re: how to create and use an pl/sql library with .ppl [message #394615 is a reply to message #394473] Sat, 28 March 2009 11:34 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

pls mention your forms version

==============

u ned to place the pll / plx in a portable path

in forms 6i its under <orahome>\TOOLS\OPEN60\PLSQLLIB\

try to place your files there, attach the files in the forms and use the proceedure / function.
Re: how to create and use an pl/sql library with .ppl [message #394735 is a reply to message #394615] Sun, 29 March 2009 23:57 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

How to make a plx from pll.
and i put the folder where i save .pll library in Orahom/tool/...
if i want to create it in form 10g then where i put the folder of .pll. what type of setting i needed.
thaks.
to attached .pll library in form 10g [message #395169 is a reply to message #394473] Tue, 31 March 2009 09:43 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

create .pll library and save it in D:\library
and go to registry and add forms_path d:\library at the end now the Form_path look as
D:\DevSuiteHome_2\cgenf61\admin;D:\DevSuiteHome_2\forms; D:\library

after that i attached library in form but it still not work.
I call the procedure of this library in when-button-pressed
begin
display;
end;
----------display is procedure of .pll library
but it still not work
what i can do further for this to solve my problem.
I am working in form 10g.
thanks
Re: to attached .pll library in form 10g [message #395172 is a reply to message #395169] Tue, 31 March 2009 09:50 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
does not work is not particularly helpful.

What does it do?
Give an error message?
If so, which one?
Re: to attached .pll library in form 10g [message #395177 is a reply to message #395172] Tue, 31 March 2009 10:03 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

i call the procedure of library as
begin
display;
end;
error 221 'display' is not a procedure or in undefined.
tell me that i follow the steps right means i create it library then saved it in folder then edit in registry to set the form_path that are the steps that i should folow or any more if so then tell me where i am going wrong.
thans
Re: to attached .pll library in form 10g [message #395195 is a reply to message #395169] Tue, 31 March 2009 10:40 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
To call a procedure in a pll you need to put:
<library_name>.<procedure_name>;


Also is the library actually attached to the form?
Re: to attached .pll library in form 10g [message #395226 is a reply to message #395169] Tue, 31 March 2009 15:17 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member


Dear David.
I hope your are only one that can solve my problem.
my problem is as:

I have create a .pll library and save it in folder d:\library and then go to envir_default variable and edit the form_path
as
FORMS_PATH=D:\DevSuiteHome_2\forms;D:\Library
and then attached the .pll to form but still not working
how i can solve my problem.
need detail steps of whole process.
thanks
Re: to attached .pll library in form 10g [message #395373 is a reply to message #395195] Wed, 01 April 2009 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Tue, 31 March 2009 16:40
To call a procedure in a pll you need to put:
<library_name>.<procedure_name>;




EDIT: typos

[Updated on: Wed, 01 April 2009 04:33]

Report message to a moderator

Re: to attached .pll library in form 10g [message #395400 is a reply to message #395169] Wed, 01 April 2009 05:33 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
Actually that's not accurate, that's what I get for doing stuff from memory.

If the library is attached to the form then only reason for getting that error is if your procedure call doesn't match the procedure definition.

So copy and paste here the procedure definition from the pll and the code that calls it in the form.
Re: how to create and use an pl/sql library with .ppl [message #395551 is a reply to message #394735] Wed, 01 April 2009 18:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I recommend that all Forms objects be placed in the same directory, and that this is the directory which you have in your 'forms_path' and which also exists in the 'Start in' property of your Forms Builder icon.

If your code in a 'pll' is "not working" then use the standard 'message:pause' pair debugging technique to determine why it is not working.

To turn a 'pll' into a 'plx' you have to 'generate' it, not just 'compile' it. By the way, you do not need to have a 'plx' for the code to be usable just make sure that the 'pll' is in the final forms directory.

Also, make sure that you select the NON-dafault option when you attach the 'pll' to your form.

David
Re: how to create and use an pl/sql library with .ppl [message #395816 is a reply to message #395551] Thu, 02 April 2009 11:59 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

No sir not working.i put the .pll in defualt folder and but still not form successfully compiled.
message:pause how i can do it.
thanks
Re: to attached .pll library in form 10g [message #395825 is a reply to message #395373] Thu, 02 April 2009 13:33 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

dear david.
I also call it as Lib_002.display
lib_002 is the name of library and display is the library procedure but still not working.
Re: to attached .pll library in form 10g [message #395930 is a reply to message #395169] Fri, 03 April 2009 02:39 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
1) I'm not David, djmartin is David. I'm cookiemonster.
2) You probably wouldn't get confused as to who you are talking to if you didn't have two threads on the same subject. So do you want to continue this discussion in your other one here.
3) Re-read my last message.
Re: how to create and use an pl/sql library with .ppl [message #396480 is a reply to message #395816] Mon, 06 April 2009 22:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the name of your library? What is the name of your form? What is the name of the directory in which you have these two items? Do you have any other non-Oracle directories in the 'forms_path' registry entry?

Create a test procedure in your library containing a 'message;pause;' pair. Call that procedure from your form.

You have attached the library to your form haven't you?

ANSWER ALL OF THESE QUESTIONS!!!

David
Re: how to create and use an pl/sql library with .ppl [message #396491 is a reply to message #396480] Mon, 06 April 2009 23:35 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Merged OP's two threads.

David
Previous Topic: Generic question
Next Topic: tree problem - not expanding
Goto Forum:
  


Current Time: Tue Dec 06 02:25:48 CST 2016

Total time taken to generate the page: 0.18951 seconds