OraFAQ Forum: Forms » Procedure in forms

Home » Developer & Programmer » Forms » Procedure in forms

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

Procedure in forms [message #178640]

Thu, 22 June 2006 01:25

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

Hi friends,

If i write any procedure in the Forms , it will store in a database ......? or it will be available only in the Forms

Thanx and Regards

Selvakumar.R

Report message to a moderator

Re: Procedure in forms [message #178647 is a reply to message #178640]

Thu, 22 June 2006 02:02

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

You can try to write a procedure in the form and then search in the database. If it exists there it means it is stored in the database. If not then obviously it's not stored in the database........please read Maaher's answer down

regards,
Saadat Ahmad

[Updated on: Thu, 22 June 2006 02:42]

Report message to a moderator

Re: Procedure in forms [message #178651 is a reply to message #178647]

Thu, 22 June 2006 02:10

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Depends: if you create it in the program units node in your object navigator it is local but if you create it in the database objects node under your schema you will have stored it in the database. Normally, you don't create database objects through Forms. There are better tools around.

In 99.9% of the cases you will only create program units, which are client-side PL/SQL objects. Client-side as in 'not on the server'. I have never created a database stored procedure through forms.

MHE

Report message to a moderator

Re: Procedure in forms [message #178654 is a reply to message #178647]

Thu, 22 June 2006 02:15

Maaher
Messages: 7065
Registered: December 2001

Senior Member

saadatahmad wrote on Thu, 22 June 2006 09:02

Good question let's see who know the answer.... Cool

Do you? Can you say with a 100% certainty where I have created my procedure through Forms? I'm sorry but the smileys you used gave me the impression you were mocking the people here on the board and the OP in particular.

MHE

Report message to a moderator

Re: Procedure in forms [message #178664 is a reply to message #178654]

Thu, 22 June 2006 02:47

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Though my intention was not to mock the people, however, I apologize for my previous reply to this post and I'll make sure that I reply in a good manner next time.

Thanks for making me realise my bad behaviour.
Hope you'll accept my apologize.

Thanks and regards,
Saadat Ahmad

Report message to a moderator

Re: Procedure in forms [message #178666 is a reply to message #178664]

Thu, 22 June 2006 03:01

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Nah, it's nothing Wink

I just wanted to point out that, although it seemed trivial, the answer is somewhat more complex than you would expect. That's all. I do agree with your 'test yourself' approach, though. Hands on experience will help you remember.

MHE

[Updated on: Thu, 22 June 2006 03:02]

Report message to a moderator

Re: Procedure in forms [message #178677 is a reply to message #178666]

Thu, 22 June 2006 03:29

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Thanks

Report message to a moderator

Previous Topic:	Block properties
Next Topic:	where will i get free ebooks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:56:47 CDT 2024