Home » Developer & Programmer » Forms » Calling DB Procedure From Forms 6i ?
Calling DB Procedure From Forms 6i ? [message #196730] Fri, 06 October 2006 17:37 Go to next message
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.
Re: Calling DB Procedure From Forms 6i ? [message #196770 is a reply to message #196730] Sat, 07 October 2006 03:27 Go to previous message
vikasg2006
Messages: 78
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
Previous Topic: how textbox disable and accept only from lov
Next Topic: CHOOSE PRINTERS
Goto Forum:
  


Current Time: Sun Dec 04 04:55:13 CST 2016

Total time taken to generate the page: 0.15874 seconds