OraFAQ Forum: Forms » how to create and use an pl/sql library with .ppl & to attached .pll library in form 10g (merged

Home » Developer & Programmer » Forms » how to create and use an pl/sql library with .ppl & to attached .pll library in form 10g (merged

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

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

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

Report message to a moderator

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

itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan

Senior Member

ashif@visititech.com

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.

Report message to a moderator

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

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.

Report message to a moderator

to attached .pll library in form 10g [message #395169 is a reply to message #394473]

Tue, 31 March 2009 09:43

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

Report message to a moderator

Re: to attached .pll library in form 10g [message #395172 is a reply to message #395169]

Tue, 31 March 2009 09:50

cookiemonster
Messages: 13963
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?

Report message to a moderator

Re: to attached .pll library in form 10g [message #395177 is a reply to message #395172]

Tue, 31 March 2009 10:03

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

Report message to a moderator

Re: to attached .pll library in form 10g [message #395195 is a reply to message #395169]

Tue, 31 March 2009 10:40

cookiemonster
Messages: 13963
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?

Report message to a moderator

Re: to attached .pll library in form 10g [message #395226 is a reply to message #395169]

Tue, 31 March 2009 15:17

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

Report message to a moderator

Re: to attached .pll library in form 10g [message #395373 is a reply to message #395195]

Wed, 01 April 2009 04:32

cookiemonster
Messages: 13963
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

cookiemonster
Messages: 13963
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.

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

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

Report message to a moderator

Re: to attached .pll library in form 10g [message #395825 is a reply to message #395373]

Thu, 02 April 2009 13:33

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.

Report message to a moderator

Re: to attached .pll library in form 10g [message #395930 is a reply to message #395169]

Fri, 03 April 2009 02:39

cookiemonster
Messages: 13963
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.

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Merged OP's two threads.

David

Report message to a moderator

Previous Topic:	Generic question
Next Topic:	tree problem - not expanding

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:48:22 CST 2025