OraFAQ Forum: Forms » Calling DB Procedure From Forms 6i ?

Home » Developer & Programmer » Forms » Calling DB Procedure From Forms 6i ?

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

Calling DB Procedure From Forms 6i ? [message #196730]

Fri, 06 October 2006 17:37

ronfranks1
Messages: 2
Registered: October 2006

Junior Member

Hello All

I have created a simple database procedure and would like to pass a value into x_old_ccc from my form and exicute the procedure. I have never done this. I usually run my procedures as program units in forms. Anyways, here is the DB procedure:

CREATE OR REPLACE PROCEDURE ccc_test (x_old_ccc IN VARCHAR2)
AS
v_rowid ROWID;
BEGIN
UPDATE ron_ccc_tbl
SET test_ccc = 'ABCD'
WHERE old_ccc = x_old_ccc;
COMMIT;
END;

Thank you in advance, Ron.

Report message to a moderator

Re: Calling DB Procedure From Forms 6i ? [message #196770 is a reply to message #196730]

Sat, 07 October 2006 03:27

vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai

Member

So!! what's the problem just inside form in plsql editor, for example inside when button press trigger just write procedure-name(:item-name);
here item name is which item value u want to pass
vikas

Report message to a moderator

Previous Topic:	how textbox disable and accept only from lov
Next Topic:	CHOOSE PRINTERS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:38:24 CDT 2024