Home » Developer & Programmer » Forms » is it possible to write a procedure inside a trigger
is it possible to write a procedure inside a trigger [message #264743] Tue, 04 September 2007 07:18 Go to next message
sauk
Messages: 29
Registered: June 2007
Junior Member
Dear friends,

i am new to pl/sql..I donno whether am asking the question in the right forum..

I ve got an oracleform 10g..In that i ve got few text items.when validating the text field i ve to check the input by using a function.i cant do it directly inside the trigger coz it looks a bit messy.

Is it possible to write a procedure or a function inside a trigger.if so is it possible to pass the runtime value as an input to the procedure?

Report message to a moderator

Re: is it possible to write a procedure inside a trigger [message #264745 is a reply to message #264743] Tue, 04 September 2007 07:32 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Write a procedure (or a function or even a package) under the "Program Units" node and call it whenever needed from any other PL/SQL code in your form (i.e. trigger, another procedure etc.).

Report message to a moderator

Re: is it possible to write a procedure inside a trigger [message #264750 is a reply to message #264743] Tue, 04 September 2007 07:54 Go to previous message
sauk
Messages: 29
Registered: June 2007
Junior Member
thanks i'll try it that way!!

Report message to a moderator

Previous Topic: How to transfer data from excel sheet to oracle using oracle forms?
Next Topic: proble of content canvas
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 01:20:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.